1. Insert a Calculated Field, follow instructions in previous page (or paragraph?).
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks