Pivot table problem

[PsyberFox]

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?

 

[Debra Dalgleish]

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 here:

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