By default, a pivot table shows only data items that have data.

In the example shown, a pivot table is used to count the rows by color.

There is no data in the months of March and May, so normally these columns would not appear.

Field list includes two fields only

Field list includes two fields only

Field list includes two fields only

Field list includes two fields only

Field list includes two fields only

Color field renamed Count in values area

Date field grouped by Months

Check “Show items with no data” for Date field

Date filter to show only desired months

Pivot table options - enter zero for items with no data