lydiapenrose
New Member
- Joined
- Nov 7, 2011
- Messages
- 22
Okay. So I have a large amount of data that tracks employees with their business line, service area, activity and hours, which they have to fill in weekly. I have a pivot table which groups so it shows the number of hours per business line or per business line + service area or per business line + service area + activity. And this sum of hours is dynamic depending on what is grouped/ungrouped.
I want a similar column in my pivot table showing a unique count of employees. So it would show that 16 employees work for Finance and 10 work for HR. But then when it expands, it shows that of those employees, 3 in HR worked on payroll, 7 worked on benefits, 9 worked in training, etc. etc.
I've been looking around and most people recommend adding another column that would put 1 if the person's name is unique, but this only works if it is sorted by one category. A person might be counted multiple times in different activities, but only once in that business line when the group is collapsed if that makes sense.
Any help would be much appreciated! Thanks
I want a similar column in my pivot table showing a unique count of employees. So it would show that 16 employees work for Finance and 10 work for HR. But then when it expands, it shows that of those employees, 3 in HR worked on payroll, 7 worked on benefits, 9 worked in training, etc. etc.
I've been looking around and most people recommend adding another column that would put 1 if the person's name is unique, but this only works if it is sorted by one category. A person might be counted multiple times in different activities, but only once in that business line when the group is collapsed if that makes sense.
Any help would be much appreciated! Thanks
