I have a pivot table with months in the column heading, is there a way that I can easily display all months even if there is no data for that month?
E.g. I have data for all months except March and June, and I want the Pivot table to include all months, including March and June.

I have manually done it by adding blank rows for all months which sort of works, but I was hoping for a more elegant solution... It is something that I will need to on an ongoing basis, so I would prefer something that I don't need to manually add data too.