Count within pivot table

[Guest]

I have a pivot table sorted by two fields; budget unit and employee name. My
source data has each employee with several rows of data (so the names show up
several times). I need a count of employees in each budget unit, not a count
of the occurence of the employee name. How do I do this? Thank you for your
help.

 

[Debra Dalgleish]

You can add a field to the source data, as described here:

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

and use that field to count the employees per budget unit.