Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a pivot table where I am representing a series of data across a number of categories as follows:

Sum of amount                     Area
Status     Priority    Project    Department 1    Department 2    Grand Total
In-flight  1a          P1               10,000                         10,000
           1b          P2               30,000                         30,000
           2           P3                               28,000         28,000
           3           P4               15,000                         15,000
In-flight total                         55,000          28,000         83,000
Pending    4           P5               16,000                         16,000
           5           P6                                1,000          1,000
           6           P7               30,000                         30,000
Pending total                           46,000           1,000         47,000
Grand Total                            101,000          29,000        130,000

I would like to add a column on the end of the pivot table that shows a cumulative running total of the Grand Total column amounts. Ideally I would like to preserve the pivot table properties, i.e. I would like to add this cumulative sum column and still be able to add and remove fields from the table. Is this possible?

share|improve this question
    
Did you ever find a solution to this? None of the answers below seem to resolve the issue. –  Icode4food Jul 31 '12 at 15:39
    
No, not so far. –  Andrew Doran Aug 13 '12 at 12:55

3 Answers 3

Have a look at this topic on the Contextures site:

Excel Pivot Table Tutorial -- Running Totals

share|improve this answer
    
Thanks, that's very useful and almost gets me there - I didn't know this feature existed. Unfortunately I would like to retain the original data alongside the cumulative or running total whereas this technique seems to let you choose one or the other. –  Andrew Doran Aug 23 '11 at 20:39

Can't reply to your comment in Doug's post as I don't have enough points, but just drag the field to the data area alongside the running total column. You can have the same field appear more than once on a pivot table.

share|improve this answer
    
You've got 10 more points now! –  Doug Glancy Aug 26 '11 at 1:38
    
I'm not sure what you mean - the Grand Total is a calculated field in the Pivot Table and not something I can drag and drop? Just to be clear, I am looking for the Grand Total as well as the 'Grand Running Total' to be two separate columns. –  Andrew Doran Feb 14 '12 at 17:09

I would up the value of this question because I want a better answer than this:

  1. Build your pivot table
  2. Select all of the values
  3. Paste special in a new sheet "Values Only"
  4. Add a "summing column" that adds previous to current
  5. Chart it!

Below is a TR submit date along with the total # of TRs for that date which the pivot table did wonderfully. Unfortunately, I wanted to see the sum over time (well, quarterly)... The procedure above got me there... curmudgeonly.

Submit_Date <--from pivot--> Total  Sum <<-- Handmade Summing Column
April 1, 2012 8:00:00 PM EDT    1   1
April 1, 2013 12:24:54 PM EDT   1   2
April 1, 2013 2:35:57 PM EDT    1   3
April 1, 2013 8:00:00 PM EDT    1   4
April 1, 2013 8:42:29 AM EDT    1   5
April 1, 2014 1:49:07 PM EDT    1   6
April 1, 2014 8:26:00 AM EDT    1   7
April 1, 2014 9:42:25 AM EDT    1   8
...
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.