1 Reply Latest reply: Aug 12, 2013 12:30 PM by Jared Papador RSS

    Pivot Table - force all options to display

    Alan Hendrickx

      Hi,

       

      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?

       

      Thanks,

      Alan