Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Philadelphia, Pennsylvania
    Thanked 0 Times in 0 Posts

    Changes between pivot table columns (Excel 2003)

    I have a Pivot Table with accounts as rows, an amount as data, with months as columns, based upon an underlying table of reports by company by account, one for each of the months. So now I want to show the "january-february" change in a column between the January and February account totals, and similarly a "Feb-Mar" change in a column between those two periods. I attempted a Calculated field with no success so far. Is this the appropriate way to do this? Not sure. It can't be a calcuated field because 1-06 and 2-06 and 3-06 are in the Month field.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Changes between pivot table columns (Excel 2003)

    Not quite what you want, but the nearest I can think of:
    - Click in the pivot table
    - Select Pivot Table | Wizard... from the pivot table toolbar.
    - Click Layout.
    - Add the Amount field a second time to the Data area.
    - Double click the new field.
    - Select Options...
    - Select % Difference with from the dropdown box.
    - Select Month as base field, and (previous) as base item.
    - Click OK.
    - Click Finish.
    - Drag the grey Data button to the right of Month (it may take more than one attempt to get it right)

Posting Permissions

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