Hello Community,
I have a problem with using variables offset for time characteristic 0CALMONTH
Let's say my current query looks like this:
...................01.2006..........02.2006..........03.2006 (0CALMONTH)
Sales ..............100..................125................200 (Keyfigure)
What I want do now is to add a previous year comparison. So that it should look this way:
...................01.2006..........02.2006..........03.2006 (0CALMONTH)
Sales ..............100..................125................200 (selected months)
LY_Sales...........50..................100................100 (selected months - 12)
(LY_Sales should show figures of 01.2005, 02.2005 and 03.2006 in this example)
I used new selection for LY_Sales with variable offset for 0CALMONTH -12 but that didn't work. Figures in second line are zero. The desired figures would show up (if I expand the selected time intervall wide enough) in 01.2005, 02.2005 and 03.2005 but that's of course not what I want.
Please help if you can!
Regards,
Ulrich