I have a pivot table where I used the "options" and "Show data as" feature selecting "% of column" to get a percentage for the total for each line item. Now I would like a column that shows a running total or cumulative percentage. A sample is shown below. I want the next column to be 31.94% for row 1, 60.74% for row two, 81.68 for rwo three etc. Problem is that I'm trying to do this on a column of data that is not in the source file but was created in the pivot table. Is there a method for achieving this result? Thanks in advance.
| Calc Pivot Example.xls | ||||||
|---|---|---|---|---|---|---|
| J | K | L | M | |||
| 5 | Data | |||||
| 6 | area | SumofQty | Sumofhours | %ofhours | ||
| 7 | 1 | 1853 | 61 | 31.94% | ||
| 8 | 2 | 1955 | 55 | 28.80% | ||
| 9 | 3 | 958 | 40 | 20.94% | ||
| 10 | 4 | 1121 | 35 | 18.32% | ||
| 11 | GrandTotal | 5887 | 191 | 100.00% | ||
Sheet7 | ||||||
