# Excel: Find Percentage Difference Between Two Columns in Pivot Table

The following step-by-step example shows how to calculate the percentage difference between two columns in a pivot table in Excel.

## Step 1: Enter the Data

First, let’s enter the following sales data for three different stores:

## Step 2: Create the Pivot Table

Next, let’s create the following pivot table to summarize the total sales by store and by year:

## Step 3: Calculate Percentage Difference Between Two Columns in the Pivot Table

Suppose we would like to create a new column in the pivot table that displays the percentage difference between the Sum of 2021 and Sum of 2022 columns.

To do so, we need to add a calculated field to the pivot table by clicking on any value in the pivot table, then clicking the PivotTable Analyze tab, then clicking Fields, Items & Sets, then Calculated Field:

In the new window that appears, type “Percentage Difference” in the Name field, then type the following in the Formula field:

```= ('2022' - '2021') / '2021'
```

Then click Add, then click OK.

This calculated field will automatically be added to the pivot table:

This new field displays the percentage difference between the 2022 and 2021 sales for each store.

For example:

• There was a 16.67% increase in sales between 2021 and 2022 for store A.
• There was a 15.44% increase in sales between 2021 and 2022 for store B.
• There was a 24.62% increase in sales between 2021 and 2022 for store C.

Feel free to highlight the values in the new field and change their format to a percentage format: