To filter Rolling 12 Months data

[Anonymous]

Hi All,

I want to get only rolling 12 months data , can anyone help me with the calculation to put in Dimension ,

TIA

[MK_QSL]

RangeSum(Above(Sum(Sales),0,12))

Calculating rolling n-period totals, averages or other aggregations

[Anonymous]

I want to filter in dimension

[MK_QSL]

It would be easy to answer if you provide sample data or sample app.

[Anonymous]

digvijay‌

[Digvijay_Singh]

Hi Raman,

The link which mrkachhiaimp provided is something like everyone followed in similar situations. If you can share sample data, you may get exact expression by someone here. I personally prefer As-of-table script based solution, it is explained in detail in the same link.

Thanks,

[Digvijay_Singh · Accepted solution]

As discussed you needed to show only last 12 months and it worked by using set expression as below -

Count({<[Order YearMonth={">=$(=Addmonths(Max([Order YearMonth]),-12))<=$(=Max([Order YearMonth]))"}>}[PO Number]

You may need monthstart() as well to show numbers from day 1 of the month.

Please close the thread by marking correct/helpful answers as many as you wish.

[Digvijay_Singh]

I fact looks like you don't need 2nd condition as I don't think you have any future data.

[itec_pao]

Hi all,

I have come across a solution, in order to provide a good moving annual total (MAT) analysis. The solution is called As-Of table. A very good example is provided here by Henric Conström:

The As-Of Table

Additionally, by using DateDiff (difference between the two dates), you might create different flags for flagging current 3months, 6months, 1Year, Ytd, etc.

Regards,

Oktay