| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
