Display all month names

Question

Hi There,

I have a requirement like within the selected Date Range, if we don't have data then also need to display the months in report.

In my case i have taken Date_From -  Date_To are 01/01/2017 to 31/12/2107, and i have the data in July and Dec only. But i want to see all the months which i don't have the data also.

Here report is displaying the months which have the data in date range.

PFA,

Thanks In Advance!

3586388 · Answer

Thanks you Gianni,

I got solution , enabled the check box for include columns with only null values.

Ramesh

3586388 · Answer

Thanks for your reply Gianni,

I have enabled the check box for include Null Row in pivot table property. Then also i dint get all the months but i get all partner values.

When i enabled check box for Include columns with only Null values, then i got result like below

I have a date range for 1 year only i.e, 2107. but am getting 2018 months as well.

Other plans would require changes in the RPD, and being OBIA:

Please suggest what changes need to do in RPD , so my requirement can full fill.

Thanks

Gianni Ceresa · Answer

A quick fix would be to check the checkbox to include NULLs in the analysis. But you can have a side effect that also all the partners will be on screen.

Other plans would require changes in the RPD, and being OBIA ... I guess it isn't really something you look for.