» PivotTable report - Adding a Data Field That Calculates the Difference Between Two Data Fields

CATEGORY - Excel Pivot Tables VERSION - All Microsoft Excel Versions

To add data fields that calculate the difference between two data fields:

Add first data field (column H in the last screenshot next page):

1. Select a cell in the PivotTable report, and from the PivotTable toolbar, click the PivotTable icon and select Formulas, and then Calculated Field.
2. In the Insert Calculated Field dialog box, type the field name in the Name box.
3. In the Fields box, select December 2003.
4. Click Insert Field, and then type the minus (-) sign in the Formula box.
5. In the Fields box, select December 2002, click Insert Field, and then click OK.

Select a cell in the new calculated field (cell H7 for example) and click the Field Setting icon on the PivotTable toolbar, Click Number, and then change the field formatting.

Add second data field (column I in the last screenshot):

6. Select a cell in the PivotTable report, and from the PivotTable toolbar, click the PivotTable icon and select Formulas, and then Calculated Field.
7. In the Insert Calculated Field dialog box, type the field name in the Name box.
8. In the Fields box, select December 2003.
9. Click Insert Field, and then type the devide (/) sign in the Formula box.
10. In the Fields box, select December 2002, click Insert Field, and then click OK.

Select cell I7, repeat step 6, select Custom, and in the Type box change the field formatting to "0.00% ;[Red](0.00%)".
Screenshot // PivotTable report - Adding a Data Field That Calculates the Difference Between Two Data Fields