I would like to have a BI query that has Actuals up to and including the input period and forecast for the remaining months.
There are a few posts here suggesting that you do this with 2 RKF's and put zero suppression on with Period in the Column set.
However, I wish to have the 12 columns plus some additional columns for other things like full year budget, prior years actuals etc. and for those columns I don't want them split by period.
Therefore I want to have some Boolean logic to take either the forecast or actuals based on the input month but in the Formula Variables to select from there is not the input variable, only an SAP current month variable.
Is there a nice way to acheive this outcome?