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?
 
Ad

Advertisements

Ad

Advertisements

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
 
Ad

Advertisements

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
 
Ad

Advertisements


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

Top