rotation 12 last months

[cristianj23a]

Hi.

I have a line graph that shows me the accumulated rotations but I need to show the rotation of the last 12 months.

For example.

If in 2016 you have 4 months of rotation, then you have to show the four months of rotation and the 8 months of rotation of the previous year.

When you do not filter, the rotation of the last 12 months should automatically appear.

Attached my qvw.

Greetings.

[marcus_sommer]

I think this could be helpful: Calculating rolling n-period totals, averages or other aggregations

- Marcus

[MK9885]

If( [Fecha EM]> monthstart(addmonths(today(),-11)) and [Fecha EM]<= today(),1) as [Rolling 12]

Use the above line in your load script.

[Rolling 12]={1} should give you previous year.

and by default use

If (GetSelectedCount ([Año EM]) = 0 ,

your expression here with adding [Rolling 12]={1} in your set expression.

[vikasdesai · Accepted solution]

Hello Friend

Please use Following Expression,

Sum({<Date={">=$(=Monthstart(max(Date)-11))<=$(=max(Date))"},Year=,Month=>} Sales)

Regards

Vikas