Pivot table - Number of values less than specified value

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
 
Top