Inserting a Field that Calculates the Difference between Two Fields in Excel 2007

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

1. Insert a Calculated Field, follow instructions in previous tip .
2. In the Insert Calculated Field dialog box, type the field title in the Name box.
3. In the Fields box, select December 2006.
4. Click Insert Field, and then type the minus (-) symbol in the Formula box.

5. In the Fields box, select December 2005, click Insert Field, and then click OK.
6. The new Calculated Field is inserted into the Data area in the PivotTable report.
7. Insert another Calculated Field, the formula in the Formula box is now:
=(December 2006/December 2005)-1.
8. Select a cell in the first calculated field (cell D8 for example), right click and select Value Field Settings, click Number Format button and change the field formatting.
9. Select a cell in the second calculated field (cell E8 for example) right click and select Value Field Settings, click Number Format button, select Custom, in the Type box insert the format: 0.00%;[Red]-0.00% and click OK.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube