Skip to Content
0
Former Member
Dec 04, 2006 at 03:13 PM

Problem with variable offset for 0CALMONTH

172 Views

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