Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables Sum of Unique Text Entries
I am working on a pivot table that I need to indicate # of employees per
status of active or termed. Within the range there may be multiple entries for one individual how would I get a count of employees by status Example of current Pivot: Emp Status Status Bus Unit Site Total(this would be 3 of emps) A Dist D. Sales Denver 0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
Pivot Tables & not printing blank rows (revisited) | Excel Discussion (Misc queries) | |||
Pivot Tables & not printing blank rows (revisited) | Excel Worksheet Functions | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |