I have another pivot table question. I am trying to calculate turnover as a % of total headcount for each division. I'm only interested in getting the percentage for people who have terminated (not the vast majority).
However whenever I hide the column containing the majority who haven't terminated - the pivot table keeps the total as 100% and recalculates the total % as the % of only those who have terminated.
Is there a way to hide this column and keep the % as a proportion of total headcount. I want to do this so that I can enable show detail on a pivot chart I will base on this pivot table.
Thanks for your help!
G0liath
--Edit:
I'm not sure on the exact protocol, but I've now posted this on another excel forum also. Am i supposed to edit the thread like this?
http://www.mrexcel.com/forum/showthread.php?t=393746
Bookmarks