Pivot Tables Sum of Unique Text Entries

J

Jen

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
 
Top