Could you please anyone help me to solve this :
I want to display 6 months rolling for cost in report
Layout should be like this :
cal/month cost(Isolated) Cost(Accumulated)
M1 M1 M1
M2 M2 M1+M2
M3 M3 M1M2M3
Points will be assigned for correct answers
You need to have calmonth or fisper or period alone in the keyfigure column at the top of strcuture.
For rolling cost you need to add say one calculated KF
CKF = RKF on Actual + rolling RKF
There will be two Fiscal period Input variable may be
One in Actual RKF for actual data
second for planning
or one Customer exit variable is sufficient and second one offset on first variable say 12- first variable value ..
Thanks and regards
Cal/Month 0COST RKF ( 0COST)
What is the content of Cal/Month ? Is it 01 format or 01/2011 format
If 01 ---Just create a formula variable with replacement path and replace the variable value with 01 or 02 or 03...so on based on the month
If 01/2011-- Just create a formula variable with User exit and get 01,02 or whatever.
Now restrict your RKF with Month Value ( Variable Value - 01).
M1 M1 M1 Here RKF will be restricted with Month Value ( 01 - 01 ) i.e 01 only
M2 M2 M1+M2 Here RKF will be restricted with Month Value ( 02 - 01 ) i.e 01 and 02 only
M3 M3 M1M2M3 Here RKF will be restricted with Month Value ( 03 - 01 ) i.e 01, 02 and 03 only
....and so on.
If you have 0FISCPER3 in your InfoProvider and that corresponds to Cal/Month then its gonna be very easy.
Let me know if the suggestion is working ....