Pivot Table - force all options to display

[#1]

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

[jpapador]

When you load in the time field in the script you could replace the null values with 0's.  Then when you create the chart turn off suppress zero values.

Something in the script like If(Len(Time) = 0, 0, Time) as RecordedTime