How to display Roll 12 Month Last Year in the same chart?

[caccio88]

Hi everyone,

i've just created a chart in which is possible to display the last 12 month in roll.
But now my issue is to display in the same chart the value of last month-year. Where the dimension is June 2011, I would like to display the sales of June 2011 and the sales of June 2010...where the dimension is May 2011, I would like to display the sales of May 2011 and the sales of May 2010...etc...

I hope I was clear enough.

I attach here my qvw to solve it.

gwassenaar‌ i'm sure you can help me...

[sunny_talwar · Accepted solution]

May be this:

Expression for LY

If(Actual > 0, Above(Sum({<YearMonth = >}Sales), 12))

[caccio88]

That's what i was looking for. Thank u so much sunindia‌!!!

[sunny_talwar]

No problem

I am glad I was able to help.

Best,

Sunny

[caccio88]

Hi sunindia‌,

do u know why when I filter a single month it can't be displayed the LY value?

Could u see my new attachment here please?

thx as usual

[sunny_talwar]

You made a selection in DateMonth field, all the calendar field where you might make a selection need to go in here for the expression to work properly:

If(Actual > 0, Above(Sum({<YearMonth = , DateMonth = , OtherCalendarFields = >}Sales), 12))