The pivot table uses all three fields in the source data: Date, Sales, and Color:

The Color field has been added as a Row field to group data by color. The Date field has been added as a Column field and grouped by year:

The Sales field has been added to the Values field twice. The first instance is a simple Sum of Sales:

The second instance of Sales has been renamed “Count”, and set to show a “Difference from” value, based on the previous year:

Note: Column H values are empty since there is no previous year. It has been hidden for cosmetic reasons only.




Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Pivot table year over year - 3Pivot table year over year - 34Pivot table year over year - 37Pivot table year over year - 99