Show actual values before current month and forecast values after

[Former Member]

This is a tricky one (but I guess it will be easy for you clever guys out there), so my apologies for the heading.

Thanks for reading.

I need to build a report in BEx (BW3.5) that does the following:

I will get actual values and forecast values for a year, grouped per period.

But in the report, I don't want to display the actual and forecast values of every period.

I want to display the actual values for the past, and the forecast values for the future.

So, if we are now in period 6 (which is June) all the actual values must be displayed for Jan, Feb, Apr and May.

But from June onwards to December, only the forecast must be displayed for each month.

Is this possible?

Thanks in advance, points will be assigned

Rudolph

Edit: This might help. The actual value is based on KF 0AMOUNT, where value type = 10. The forecast is based on the same KF, value type = 20, version = F2

[Former Member · Accepted solution]

Hi Rudolph,

This is possible, you just need to create restricted key figures using fiscper or period/fiscal year. And use offset property. Create a customer exit variable which will derive current month and then use this for each columns with offset -1,-2.......

hope this helps. if need more details ...let me know...

Regards

Rajesh

[Former Member · Accepted solution]

I think this will work....