Calculating percentages in pivot tables on subtotals
I want to calculate percentages of a column in a pivot table based on the
subtotal, not the column total. How do I do that?
For example:
Campus A Coded 10
Coded % 25%
Not Coded 30
Not Coded % 75%
Total Campus A 40
Campus B Coded 20
Coded % 50%
Not Coded 20
Not Coded % 50%
Total Campus B 40
Total 80
--
David Ruderman
Director of Marketing
Chapman University
|