Restrict dimension for 12 month

[Rocky6]

Hi All,

I have a requirement where i need to restrict the dimension part for last 12 months. 

can anyone help me in this. 

Thanks in advance 

[Chirantha]

Hey,

You can use set analysis to restrict the dimension to show data for the last 12 months. For example, if your dimension is ''MonthYear'' and your measure is ''Sales'', you can use the following expression to show the sum of sales for the last 12 months:

Sum({<MonthYear={">=$(=AddMonths(Max(MonthYear),-12))<=$(=Max(MonthYear))"}>} Sales)
 

[Rocky6]

Hi Chirantha,

Thanks for your reply i need to show in dimension part not in the measure part.