Hierarchy Calendar

[Anonymous]

Hi all, 

Below given is the sample data for calendar i have, i want to display this in hierarchy format in the dashboard.

TestCalender:

LOAD * INLINE [

    Date, [Financial Year], Year, Quarter, Month

    01-07-2017,FY17, 2017, Q1, July

    01-08-2017,FY17, 2017, Q1, August

    01-09-2017,FY17, 2017, Q1, Spetember

    01-10-2017,FY17, 2017, Q2, October

    01-11-2017,FY17, 2017, Q2, Novmber

    01-12-2017,FY17, 2017, Q2, December

    01-01-2018,FY18, 2018, Q3, January

    01-02-2018,FY18, 2018, Q3, February

    01-03-2018,FY18, 2018, Q3, March

    01-04-2018,FY18, 2018, Q4, April

    01-05-2018,FY18, 2018, Q4, May

    01-06-2018,FY18, 2018, Q4, June

];

Kindly help on how to display this.

Thanks in advance

[Anonymous]

ctrl works but i want an automatic option.

any ideas ?

[YoussefBelloum]

I don't think there is another alternative in this scenario because when you make a selection, you're selecting unique Date value which correspond only to that date, everything else goes grey I suppose, each selection will override the previous one..