Fields
The pivot table shown is based on two fields: Date and Color:
The Color field is configured as a row field, and a value field. In the Values area, the Color field has been renamed “Count” and set to summarize by count:
The Date field is grouped by Months only:
To force display of months with no data, the Date field has “Show items with no data” enabled:
Date filter is set to display only desired months:
To force the pivot table to display zero when items have no data, a zero is entered in general pivot table options:
Steps
Notes
Author
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.