Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Restructuring: Using Pivot Table w\o the SUM, COUNT etc. Function? | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Count unique values - Pivot Table | Charts and Charting in Excel | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot table Data always showing up as "Count" | Excel Discussion (Misc queries) |