View Single Post
  #1   Report Post  
David Ruderman - Chapman University
 
Posts: n/a
Default 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