Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding Calculated Field in Pivot Table (2003)

    I have two sets of columnar data in Excel that I would like to subtract. How do I add a calculated field to subtract these 2 items?

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

    Re: Adding Calculated Field in Pivot Table (2003)

    Say that the columns are named This and That.
    Click anywhere in the pivot table.
    From the Pivot Table toolbar, select Pivot Table | Formulas | Calculated Field.
    Enter a name for the calculated field, e.g. Difference.
    In the formula box, enter the formula =This-That
    Click Add, then OK.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Calculated Field in Pivot Table (2003)

    Hans, thanks... Not real sure how to do this. Let me add more info. The PT is laid out as follows:
    - Row has "project name"
    - Column has "versions" in it. 1 version is 2008 OP and the other is Sept LE
    - Data has Amount (summed) in it

    I'd like to subtract Sept LE from 2008 OP. Don't see those as the available fields when I follow the instructions. Am I doing something wrong?

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

    Re: Adding Calculated Field in Pivot Table (2003)

    Sorry, I interpreted your "I have two sets of columnar data" in a different way than you intended it. What you need is a calculated item instead of a calculated formula.
    - Click in one of the values of version.
    - From the Pivot Table toolbar, select Pivot Table | Formulas | Calculated Item...
    - Enter a name for the formula in the box at the top.
    - Enter the following formula in the formula box:
    <code>
    =versions[2008 OP]-versions[Sept LE]
    </code>
    - Make sure that you use the names exactly as they are in the data.
    - Click Add, then OK.

Posting Permissions

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