Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 31st 20, 09:03 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2020
Posts: 1
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Running Sum % Charlie Bamford Excel Discussion (Misc queries) 10 September 19th 12 08:53 PM
Running Total in Pivot Table Lee Excel Discussion (Misc queries) 2 March 6th 07 07:43 AM
Pivot Table - Running Calculation Dimitri Excel Discussion (Misc queries) 4 February 9th 06 04:57 PM
How do I do running Totals in a Pivot Table Pivot Freak Excel Worksheet Functions 2 February 7th 06 06:30 PM
% of running total in pivot table eggman Excel Discussion (Misc queries) 0 October 13th 05 04:31 PM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017