Count within pivot table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sandy - 19 Oct 2006 20:35 GMT

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.

Reply to this Message

Debra Dalgleish - 20 Oct 2006 00:48 GMT

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.

> 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.

Signature

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

Reply to this Message