My data contains a list of resources and the time that these resources have recorded each month for up to 12 months.
I am displaying this information in a Pivot Table which works fine when looking at all of the resources as all months are visible. The issue that I am having is when an individual resource is selected and they have not recorded time, the blank month does not display at all.
I would like all months to display with zero or null displayed under the 'empty' month. Is this possible?