Actual N-1 + Planning N with dynamic 0FISCPER
Hi have a request to display in a report a structure with 2 columns:
- Actual data year N-1 (Infoprovider A)
- Planned data year N (Infoprovider B)
0FISCPER is on top of the structure so that the structure can extend dynamically.
There is also a range with 2 variables in static filter for 0FISCPER (Fiscper from & Fiscper to).
I use "constant selection" in column Actual data with an offset [Fiscper from -12 -> Fiscper to -12] so that I can display Actuals N-1 compared to planned data N.
My issue is that I can find a way to display more than 12 months.
For example, if I select 001.2014 to 006.2015 (18 months), Actuals 001.2014 and 001.2015 are cumulated.
Thanks for your help.
Choose standard variable for current fiscal period and keep it in your monthly columns.
Choose another variable with range which will accept input from user. Use this variable for these two key figures.
So that in this variable, you can give date range and get the expected results as well.
You can achieve it with single variable as well by taking lower range consideration for monthly calculations.
Hope answering - Kumar