Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
I've found the same problem, my work around is to ..
Use the "Page area" in the Wizard to store the primary field. This allows you isolate the data into smaller groups where the sub total of the large group now becomes the total of this subset. I know it's not what your looking for exactly but it should get you the numbers your looking for. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Pivot Tables & Percentages | Excel Discussion (Misc queries) |