Difference in percentage calculation – Part 2

In the third example, we calculate the percentage difference in a PivotTable. We first convert the data from cells B2 to D17 to a PivotTable (see Course Excel 2007 Lesson 47).
Next, we select a cell in the PivotTable (it does not matter which cell is selected) and we click on “PivotTable Tools” in the ribbon. Select the “Options” (10) tab, click on “Fields, items and sets” (11) and select “Calculated Field “(12).

In the “Insert Calculated Field” dialog box, we enter an appropriate name in the “Name” box eg., % difference and in the “Formula” box, we remove the zero (13)

We place the cursor in the “Formula” box after the equal sign. We then double-click on the name “February” type the slash “/”, double-click on the name “Jan”, type the minus sign followed by 1 (14) and click OK (15 ).

Then we double-click the field name “Sum of% difference” (16).

And in the “Value Field Settings” dialog box, under “Custom Name”, we delete the text “Sum of” and type “January and February” after the “% difference” (17) text and click on “Number Format” (18).

In the “Format Cells” dialog box, select “Percentage” (19) and click Ok (20).

Result of this operation:

FYI: Swotster.com thinks of its students, so you also remember swotster.com.

Back to Part 1
Part 1 – Part 2

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats