Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Actual N-1 + Planning N with dynamic 0FISCPER

Hi all,

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.

Ronan

Former Member
Former Member replied

Hi Ronan,

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question