Count within pivot table
 

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.

Count within pivot table
 

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

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

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

sandy wrote:
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
Contextures
http://www.contextures.com/tiptech.html