How to combine actuals with forecast for remaining period and be with cumulative line
Hi All,
I have a question about How to combine actuals with forecast for remaining period and be with the cumulative line.
I have to measures: Forecast and Actual and 2 line charts.
1 showing actual sales (up to the end of this month) and 1 showing forecast sales (from this month to the end of the year).The Actual should be visible until now and the Forecast should be visible after today.
I want to combine them in one line and the line to be cumulative.
For the cumulative and be visible only until today, I'm using expressions like this:
create a cumulative of Actuals, in a second expression, add the cumulative of Forecast to the total of actuals. make sure Forecast starts where actuals end (today()) with zero forecast amount so that the 2 charts are connected.