Pivot Table Question

[PraveshG81]

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 School (vertical) and current status (horizontal) this will get very difficult.

Thanks for your help!