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
add comment

2 Answers

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
add comment

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
add comment

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.