Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable - Percent of Current Total
I have a pivottable like this:
Col W Col Z Total Row X 19 4 23 Row Y 12 6 18 I want to summarize the data by showing a percent of the current running total. For example: Col W Col Z Row X (19/23) 82.6 (4/23) 17.4 Row Y (31/41) 75.6 (10/41) 24.4 I tried to to a calculated field (ColW/(ColW + ColZ)). Then set the pivot chart to do a running total, but I got the following results: Col W Col Z Row X 82.6 17.4 Row Y 158.2 41.8 Is there a way to achieve what I want in Excel? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable - Percent of Current Total
On Oct 23, 11:09 am, rzaleski wrote:
I have a pivottable like this: Col W Col Z Total Row X 19 4 23 Row Y 12 6 18 I want to summarize the data by showing a percent of the current running total. For example: Col W Col Z Row X (19/23) 82.6 (4/23) 17.4 Row Y (31/41) 75.6 (10/41) 24.4 I tried to to a calculated field (ColW/(ColW + ColZ)). Then set the pivot chart to do a running total, but I got the following results: Col W Col Z Row X 82.6 17.4 Row Y 158.2 41.8 Is there a way to achieve what I want in Excel? I basically want to have a calculated item that is displayed as normal and have the other items displayed as a running total. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non Adjacent percent average total | Excel Discussion (Misc queries) | |||
HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER? | Excel Worksheet Functions | |||
Sorting High to Low based on percent of total | Excel Discussion (Misc queries) | |||
PivotTable-% of total | Excel Worksheet Functions | |||
Percent of total in Pivot tables | Excel Worksheet Functions |