| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Percent Question
We have a pivot table of this form:
Type SubType Amount a a 3 b 7 a Total 10 b a 11 b b 15 b total 26 We need to get another column to percent the amount as a percentage of the subtotal rows... for instance, 3 is 30% of the 'a Total' subtotal, 7 is 70%, 11 is 42.3% of 26, 15 is 57.7% of 26 etc. I can't seem to find the right setting to do that. Help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Pivot Table How to Sort data as Percent of Row | Excel Worksheet Functions | |||
| How do I calculate "cummulative percent of total" in a pivot table | Excel Discussion (Misc queries) | |||
| Percent (field1/ field2) on pivot table | Excel Discussion (Misc queries) | |||
| Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
| Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
Threaded Mode
