» 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%)".
Book Store:
Recommended Books:
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The 22 Immutable Laws of Branding
- The Ernst & Young Business Plan Guide
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Marketing Plans
No comments have been submitted.
