In this example, a pivot table is used to show the year-over-year change in sales across 4 categories.

Change can be displayed as the numeric difference (this example) or as a percentage.

It has been hidden for cosmetic reasons only.

Pivot table year over year comparison

Steps

Notes

Pivot table year over year comparison

Pivot table year over year comparison

Pivot table year over year comparison

Pivot table year over year comparison

Date grouped by year only

Pivot table year over year comparison sales field settings

Change field settings