Pivot table - Show column even if there is no data

[GamelinC]

Hello,

I'm creating a pivot table report on the asset table with column Schedule Retirement Date and row Model. Is there a way to add date column even if there is no data to show

My result is showing all the months except February because I do not have any computer with a schedule retirement date in Feb. but I would like to still show a column with Feb. but with 0.

Thanks

[Vigneshwar Redd]

Hi,

Can you please try checking if "Show all" is selected in Max number of Rows and also Show Other check box is checked to show all data.
Also please check your filter if any filter is applied.

Hope this helps..!!!

Thanks