Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot - calculate diff (2003 SR2)

    We have a pivot table (screen shot attached), and we want to calculate the difference between Period A and B. How can we have the pivot table do this calculation?
    Attached Images Attached Images

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

    Re: Pivot - calculate diff (2003 SR2)

    Click in the pivot table.
    Select Pivot Table | Wizard... from the Pivot table toolbar.
    Click Layout...
    Add the same field to the Data area that is already there.
    Double click the new field.
    Click Options >>
    Select "Difference from" in the dropdown list.
    Select Region in the list of base fields.
    Select (previous) in the list of base items.
    Click OK etc.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot - calculate diff (2003 SR2)

    Never mind.. I am rescinding this post. In talking with the user, it appears we cannot format the data correctly to do the calculation in the pivot table. Thanks anyway for your time!

Posting Permissions

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