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.

[sunny_talwar · Accepted solution]

Does this look like what you wanted?

[cristianj23a]

Hi Sunny.

I wish that I get an image similar to the one below, with the same values.

For example if I do not make any filter has to appear the rotation until the last month of 2017, in this case October and to the side would be the rest that are November and December of 2016

Attached a new qvw

Greetings.

[sunny_talwar]

Not sure if I can get the line... but the sorting of the month can be fixed

[cristianj23a]

That is the order of dates that I will also need after the values come out.

I am using this expression

[Fecha EM]={">=$(=(AddMonths(Max([Fecha EM]),-12)))<=$(=(AddMonths(Max([Fecha EM]),0)))"}

and it filters me but when I add the variable $ (= vTop1RotaciónInsumos) changes the values, I also have to modify that variable so that I get what I require

[vikasdesai]

Hello Friend

Please use Following Expression,

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

Regards

Vikas