Pivot Table Running Sum %

C

Charlie Bamford

I can calculate a Running Sum in Pivot Tables. I can also insert a column
showing what percentage of the column total each line represents. However, I
can't work out how to show the running total %. My data is sorted so that
the largest value is at the top of the table. This represents 20% of the
total for that category i.e. the subtotal. The next row accounts for 14% of
the total. So, what I'd like to see is a column showing a cumulative %
against this second row of 34%. As we move down the table the percntage will
move towards 100%. After the subtotal the running % total will start again
from zero.

Can anybody help please?
 
P

PJS

I can't seem to duplicate this on a different spreadsheet T_T
The formula seems to be designed to look at a specific range of cells?
I get an error message when I copy and paste the formula to another
spreadsheet with my own data.

Can someone please explain why this is so?

Thanks,

PJS
 
T

thijs.weber

Dear Herbert,
I am having the same problem, but am unable to download the file.
Could you send it to me in some other way?

thank you very much in advance!

rgds,
THijs
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table percentages 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
Getting Text data using the Data - Subtotal feature 1
Conditional SUBTOTAL in XL210 Table 7
% of subtotal in pivot table 1
Average of Subtotals in Pivot Table 0
Pivot Table Grand Total Plus Calc Field or GT Running Balance 6
Pivot Table Calculated Field - Sum/count 1

Top