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

    Pivot Table - Calculated Field (2002)

    Is it possible to insert a calculated field within a pivot table? If so, how.

    Thanks!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Pivot Table - Calculated Field (2002)

    From help
    <hr>Add a calculated field

    1.Click the report.
    2.On the PivotTable toolbar, click PivotTable or PivotChart, point to Formulas, and then click Calculated Field.
    3.In the Name box, type a name for the field.
    4.In the Formula box, enter the formula for the field.
    5.To use the data from another field in the formula, click the field in the Fields box, and then click Insert Field. For example, to calculate a 15% commission on each value in the Sales field, you could enter = Sales * 15%.

    Add a calculated item to a field

    1.If items in the field are grouped, right-click each group, point to Group and Outline on the shortcut menu, and then click Ungroup.
    2.Click the field where you want to add the calculated item.
    3.On the PivotTable toolbar, click PivotTable or PivotChart, point to Formulas, and then click Calculated Item.
    4.In the Name box, type a name for the calculated item.
    5.In the Formula box, enter the formula for the item.
    To use the data from an item in the formula, click the item in the Items list, and then click Insert Item (the item must be from the same field as the calculated item).
    6.Click Add, and then click OK.
    7.If you ungrouped items in step 1, regroup them if you want. <hr>

    Steve

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

    Re: Pivot Table - Calculated Field (2002)

    Select any cell in the pivot table.
    Click Pivot Table on the Pivot table toolbar.
    Select Formulas | Calculated Field...
    Specify a name for the calculated field and a formula. For example, if your pivot table contains a field Amount, you could use

    =Amount*1.06+10

    indicating that you want to add 6% and a fixed amount of 10 to Amount.
    Click Add.
    Click OK.

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

    Re: Pivot Table - Calculated Field (2002)

    Thanks to both.

Posting Permissions

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