Hi,

This might be a bit tricky to explain, but let me try...

I have some data whereby production is captured against operators...
different quantities for different operators. Now, when I pivot this
information, I would like to have a scenario where the pivot shows production
per no of operators. This should be the actual number of operators, and not
just sum of operators... hope this makes sense.

Is this possible?

There's no function in a pivot table that will count unique items. As a
workaround, you could add a field to the source data, to calculate the
count of operators, and add that field to the pivot table. There's an
example he

http://www.contextures.com/xlPivot07.html#Unique

PsyberFox wrote:
I have some data whereby production is captured against operators...
different quantities for different operators. Now, when I pivot this
information, I would like to have a scenario where the pivot shows production
per no of operators. This should be the actual number of operators, and not
just sum of operators... hope this makes sense.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html