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