How to SUM data of last 12 months

[jorditorras]

Hi Qlik Gurus,

I have a Qlikview App which one of its Expressions is being calculated by a variable:

$(vG.Measure.ST.Accum.Rotation.Value.Consumption)

This variable is showing the Consumption of stock of the selected period.

Is it possible to calculate Consumption of last 12 months (of maximum selected date) using this variable by adding any Qlikview function in the expression?

Thanks in advance.

Regards,

Jordi

[Anil_Babu_Samineni]

We can use this?

Sum({<$(vG.Measure.ST.Accum.Rotation.Value.Consumption), MonthField = {">=$(AddMonths(=Max(MonthField),-3)) <=$(=Max(MonthField))"}>}Sales)

Or

Sum({<MonthField = {">=$(AddMonths(=Max(MonthField),-3)) <=$(=Max(MonthField))"}>} $(vG.Measure.ST.Accum.Rotation.Value.Consumption))