Pivot table - Number of values less than specified value

  • Thread starter Thread starter Sean
  • Start date Start date
S

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
 
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.
 
Back
Top