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!
I've also posted asked this question at excelforums:
http://www.excelforum.com/excel-general/685832-pivot-table-show-total-when-one-column-is-hidden.html
G0liath
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!
I've also posted asked this question at excelforums:
http://www.excelforum.com/excel-general/685832-pivot-table-show-total-when-one-column-is-hidden.html
G0liath
