ExcelBanter - Displaying all months in a time dimension when values are Zero

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Displaying all months in a time dimension when values are Zero (https://www.excelbanter.com/excel-discussion-misc-queries/113011-displaying-all-months-time-dimension-when-values-zero.html)

BDG Walter

Displaying all months in a time dimension when values are Zero

My pivot table only seems to pick up non-zero months in my time dimension.
How can I get it to recognize all dimensions.
--
Walter Corcoran
Boston Data Group

All times are GMT +1. The time now is 05:39 PM.