Remember Me?

#1
October 31st 20, 08:03 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Oct 2020 Posts: 1
Pivot Table Running Sum %

Hi there

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 percentage will
move towards 100%. After the subtotal the running % total will start again
from zero.Can anybody help please?

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Charlie Bamford Excel Discussion (Misc queries) 10 September 19th 12 08:53 PM Lee Excel Discussion (Misc queries) 2 March 6th 07 06:43 AM Dimitri Excel Discussion (Misc queries) 4 February 9th 06 03:57 PM Pivot Freak Excel Worksheet Functions 2 February 7th 06 05:30 PM eggman Excel Discussion (Misc queries) 0 October 13th 05 04:31 PM

All times are GMT +1. The time now is 09:26 PM.