Pivot table - Number of values less than specified value

[Sean]

Hi,

I have a table of data which includes and area number for each item (1
to 10) and a length for each item. I would like to find out how many
lengths are less than a specified threshold, in each area.

Is there a function in pivot tables that can tell me this?

Any assistance will be appreciated.

Thanks

Sean

 

[Debra Dalgleish]

There's nothing in a pivot table that will calculate that. You could add
a field to the source data, and use a formula to return a 1 if the
length is less than the threshold. Then, add that field to the pivot
table, and sum the amount.

 

[Sean]

Hi,

Thanks Debra. I was starting down that route. It is good to know for sure.

Sean