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|