Question:
Hi Guys,
There is a Report requirement to display last year's data along with current yr values by using fiscal year period (0FISCPER) .
In the query, the Fiscal Year Period comes as a selection.
For ex. for Fiscal Yr Period from 01.2004 to 12.2004, following values of the key figure: Actual Amt has to be shown.
Current Yr (2004) | Last Yr (2003)
-------------------------------------------------------------------
Actual Amt | Actual Amt
--------------------------------------------------------------
01.2004 | 02.2004.... | 01.2003 | 02.2003....
-------------------------------------------------------------------------
$ 232.00 | $ 129.00 .... | $ 321.00 | $ 342.00
...
...
...
Please advise if this can be achieved WITHOUT using a userexit.
Thanks in advance,
SZ
Answer:
Use offsets on your selection.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Created 2 RKF on ur actual KF. ACTUAL AMOUNT
include 0FISCPER. for First RKF (Current Year) ACTUAL AMOUNT.
include 0FISCPER with OFFSET -1 for Second RKF( Last year) ACTUAL AMOUNT .
Hope m clear
_________________
Chetan
@ CP...
Answer:
Hi Chetan ,
Thanks for u'r reply , But plzs tell whether the off set will be -1 or -12
Bye
SZ
Answer:
SZ
Well the OFFSETS r in to Variable itself (ex:0FISCPER) ,double click it for the OFFSET.
_________________
Chetan
@ CP...