Skip to Content
0
Former Member
Mar 16, 2007 at 11:01 AM

Variable offset

9 Views

If the user enters in the selection screen like 01.2007 then it should show me Actual Amount of 01.2007 & target amount of 01.2008

I have created 2 restricted keyfigures one with Amount ,calmonth restricted with manual input value

one with Amount ,calmonth restricted with manual input value specified with offset value 1

but when I run the query & enter 01.2007 in selection screen then its displaying me only the actual amount & Target amount is showing me blank

& if I specify offset value for calyear its working fine in the selection screen if I give 2007 but the data is showing like this

Material Actual Target

Jan 07 Feb07 Jan 08 Feb 08 Jan 07 Feb07 Jan 08 Feb08

1400000 500 300 600 400

But I want the data to be in this format

Material Actual Target

Jan 2007 Feb2007 Jan 2008 Feb 2008

1400000 500 500 500 500

Pls tell me how is this possible