Drill Down- Last year, last month, last week

[msmSahaj]

Hi Everyone,

Currently i have Chart based on Year-month.  I have retirement to drill down to last year, last month, last week.

       1. If chart x axis is year then by click on year should display all month.

      2. If chart x axis is month then by click any month should display weeks of that month(min 4 weeks if  3 week completed  month on this month, then previous month last week)

    3. if chart x axis is week then click on any week should display all 7 day. 

Below is my table, I need to calculate based on year-month column.  Please help related this expression.

Thanks 

Year-Month	Last Week	Last Month	Last Year
2014-12	no	no	yes
2014-12	no	no	yes
2014-12	no	no	yes
2014-12	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-11	no	no	yes
2014-10	no	no	yes
2014-10	yes	yes	yes
2014-10	no	no	yes
2014-10	no	yes	yes
2015-01	yes	yes	yes
2015-01	yes	yes	yes
2015-01	no	no	yes
2015-01

[msmSahaj]

Hi  @timpoismans can you please check this issue , it with in the previous task 

[timpoismans]

Hi there Sahaj

I've been out the last two weeks, so sorry for my late reply.

If you have a calendar added to your application, you can create a Master Dimension - Drilldown, which will do exactly what you want.
First it would display all years. Selecting a year would display all months in that year. Selecting a month would display all weeks in that month and selecting a week would display all days in that week.

You'd need to add the [Year]-[Month]-[Week]-[Day] fields from your calendar to the drilldown dimension you're creating.

Regards,

Tim P.