Master Calendar Help.

[#1]

Hi all,

For the master calendar, I am taking the minimum and maximum date date from my data and creating it. But now I want that irrespective of data, all the months and dates should be shown and there is no data then it should be grayed out.

For Example :

I have data from Jan 2015 to July 2015. Then all the months i.e. Jan to Dec should be shown with Aug, Sep, Oct, Nov and Dec greyed out like below:

instead of

[MarcoWedel · Accepted solution]

don't use

Min(Date) and Max(Date)

but something like

YearStart(Min(Date)) and YearEnd(Max(Date))

as limits in your calendar script.

regards

Marco

[MarcoWedel]

or additionally load all months in a subsequent load like

LOAD Month(Date#(RecNo(),'M')) as Month
Autogenerate 12;

hope this helps

regards

Marco