Show last 13 months based on current month

[manu1512]

Hi all,

i had a field reportmonth which has value like 2018-01,2018-02.

It is in text value .

i want to show use this as as dimension as chart. but in dimension i want to show only last 13 months date.

Can any one suggest me what to do ....it seems my logic is not working

Kind Regards

[rahulpawarb]

Please use Master Calendar and use below configuration.

//Dimension

reportmonth

//Measure

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

Hope this will help.

- Rahul