Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How to create an accumulate total field in Pivot Table?

  1. #1
    Guest

    Default

    Region (All)

    Sum of SalesAmount
    Time Total Accumulate Total
    2001-Dec 650 650
    2001-Nov 450 1100
    2001-Oct 250 1350
    2002-Feb 1050 2400
    2002-Jan 850 3250
    Grand Total 3250


  2. #2
    Guest

    Default

    Place a 2nd copy of 'SalesAmount' field button in your PivotTable's DATA area. While still in the PivotTable wizard, double-click the 'Sum of SalesAmount2' field button and press [ Options>> ]. Set the "Show data as" drop down list to "Running Total In" with a "Base field" of "Time" and press [ OK ]. Double-click the 'Sum of SalesAmount2' field button once more and change it's "Name" to "Accumulate Total".

    Press the wizard's [ Finish ] button.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've tried and it's worked. Thank you very much.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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