Hi
I am using a pivot table to display some data. I am sorting by oranization then by status then by the employee. I need to count the # of instances of an employee ID but if they are the same I want it to count as 1 instance. How can I do that?
Example:
Org: Human Resources
Stauts: A - 456
Status: A - 456
Status: A - 321
Count of A = 2 not 3

Thank you