| 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) | |||
Linear Mode
