Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jan 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    pivot table running totals calc (excel 2003)

    I have a pivot table witha calculated field which I have set for running totals, which is working fine. But when I select that field in an equation for another caluclated filed, it only adds the sum, not the runnng total sum. Anyone have any ideas ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: pivot table running totals calc (excel 2003)

    Welcome to Woody's Lounge!

    I think you'll have to replace the calculated field with its formula in the expression for the new calculated field.

  3. #3
    New Lounger
    Join Date
    Jan 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: pivot table running totals calc (excel 2003)

    I had tried that too and it still doesnt calculate on the running total. Its very perplexing. thanks.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: pivot table running totals calc (excel 2003)

    Could you post a copy of your workbook, with sensitive information removed or altered, and zipped if necessary? (Max size for attachments is 100 KB)

  5. #5
    New Lounger
    Join Date
    Jan 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: pivot table running totals calc (excel 2003)

    Go to worksheet Plumbing, that has pivot table, the field SALES YTD is set as running total in field options. I need the running total to be included in the calulated field TRACKING. I am trying to help someone with this, so I didnt create this mess only trying to fix. lol.
    Attached Files Attached Files

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: pivot table running totals calc (excel 2003)

    I notice that Tracking hasn't been set up to display a running total.

Posting Permissions

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