Results 1 to 3 of 3

Thread: How to Minus one Running Total column from another inside Pivot?

  1. #1
    Neophyte sjclarkey's Avatar
    Join Date
    Sep 2014
    Location
    Kent
    Posts
    1
    Articles
    0

    How to Minus one Running Total column from another inside Pivot?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, In my pivot chart I want a column that shows the difference between a cumulative budget and cumulative actual column. I have created these cumulative value columns by using the Field Setting/Use data/'Running Total In' facility. However when I try and use the Calculated Field function so that I can minus one field from the other these fields are not available in the list to choose from. I assume Excel does not see them a real fields. How can I get around this?

    My Pivot should look like this

    Month Actual Budget Cumulative Actual Cumulative Budget Cumulative Difference

    Jan 1000 500 1000 500 -500
    Feb 1250 2500 3250 3000 250


    Thanks

  2. #2
    Excel 2010 with free PowerPivot Add-In
    All of the previous Calculated Fields/Items shortcomings have been fixed in PowerPivot.
    http://www.mediafire.com/view/plc49h.../10_02_14.xlsx

  3. #3

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •