hierarchy calender

[Anonymous]

Hi Experts ,

I have the following data loaded in the Report :

LOAD RequestId ,

     DisplayId ,

     CreatedBy,

     Date,

     Year,

     MonthNumber,

     MonthName,

     Quarter,

     FinancialYear

From ViewName;

I want to display the Financial Year >> Year >> Quarter>> MonthName in the hierarchial manner in the Dashboard.

I tried using the Hierarchial load method.

But that doesnt seem to be working.

Kindly Suggest on how can this be acheived.

Thanks in advance

[YoussefBelloum]

you're welcome

[Anonymous]

HI Youssef,

I would require your help again.

In the code which you have helped me in implementing the hierarchy calander.

the calendar displays in the order of

   FY--> YYYY--> Q --> M --> Date

but when i click on 2nd hierarchy level i.e YYYY the data is displaying for all the months under the respective year selected.

here in my case the FY ranges from July to june.

So is it possible to implement this july to june option in the calender.

i.e when FY-17 is selected the years 2017 and 2018 will come up .

and when 2018 is selected only those months which belong to 2018 AND FY-17 would come up.

Kindly suggest on this,

Thanks

[Pragya]

Hi Youssef, 

Could you please suggest how should i concatenate field  and use the "show as treeview" option in a listbox as i am looking for the output with year-quarter-month in the drill down view as in the screenshot below? If i can get the output as in the screenshot below, i am in luck then. Could you please help?