Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
May be this:
Expression for LY
If(Actual > 0, Above(Sum({<YearMonth = >}Sales), 12))
May be this:
Expression for LY
If(Actual > 0, Above(Sum({<YearMonth = >}Sales), 12))
That's what i was looking for. Thank u so much sunindia!!!
No problem
I am glad I was able to help.
Best,
Sunny
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
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))