| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Obtaining a Running percentage in a Pivot Table Vlue Zone.
Hi,
I have another Pivot table problem. I have a table showing this in the values zone: Line 1 35 16 8 19 45 32 47 4 1 207 Line 2 17% 8% 4% 9% 22% 15% 23% 2% 0% 100% Line 3 35 51 59 78 123 155 202 206 207 Line 1 is counts of stuff. + a total Line 2 is counts of stuff (i.e. Line 1) in percentage format. + a total Line 3 is a running subtotal of Line 1 ... + a total Line 4 17% 25% 29% 38% 59% 75% 98% 100% 100% All I need now (in Line 4) is the running percentage of Line 3 17% +8% = 25% etc. How please would I do that ? TIA rosalie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Running Sum % | Excel Discussion (Misc queries) | |||
| Pivot Table Percentage of Sub-Total | Excel Worksheet Functions | |||
| Pivot table, display a value underneath another value in the values zone. | Excel Discussion (Misc queries) | |||
| Need running percentage in pivot table | Excel Discussion (Misc queries) | |||
| How to add a percentage column in a Pivot Table | Excel Discussion (Misc queries) | |||
Linear Mode
