PraveshG81
New member
- Joined
- Oct 6, 2011
- Messages
- 22
- Reaction score
- 0
- Points
- 0
Hello,
I was hoping someone could help me build a pivot table that would tell me how much headcount we have in a Practice Group based on an applicant's application status. So, for example, in the Raw Data tab Person 1 wants to be in two practice groups, so he would be a .5 headcount in one group and .5 headcount in a second group. Person 2 wants to be only in one group so he is 1 headcount in that practice group.
What I am currently doing in the School_Practice Group tab is creating one pivot table to do a head count for practice group preference 1 and a second pivot table for practice group preference 2 and then adding those value together on a 3rd calculated table.
Is there anyway to do this in just one pivot table? Right now this is simple but if slice this data by say: Practice Group by Law Schoo (vertical) and current status (horizontal) this will get very difficult.
Thanks for your help!
I was hoping someone could help me build a pivot table that would tell me how much headcount we have in a Practice Group based on an applicant's application status. So, for example, in the Raw Data tab Person 1 wants to be in two practice groups, so he would be a .5 headcount in one group and .5 headcount in a second group. Person 2 wants to be only in one group so he is 1 headcount in that practice group.
What I am currently doing in the School_Practice Group tab is creating one pivot table to do a head count for practice group preference 1 and a second pivot table for practice group preference 2 and then adding those value together on a 3rd calculated table.
Is there anyway to do this in just one pivot table? Right now this is simple but if slice this data by say: Practice Group by Law Schoo (vertical) and current status (horizontal) this will get very difficult.
Thanks for your help!