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
 
D

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.
 
S

Sean

Hi,

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

Sean
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top