I need help creating a dynamic column, that switches between Actuals 2018 and Forecasts 2019.
The table currently looks like the below, with forecasts 2019 being the dynamic column:
The user has to have the option to toggle between actuals 2018 or forecasts 2019. Perhaps a parameter? The option to toggle between these two fields has to appear as a slicer on the report ideally.
When choosing actuals 2018 or forecasts 2019 for the dynamic column, the actual 2019 column would not be affected, but the variance and variance % would change. The calculation for variance = (Actual 2019 - (Actual 2018 or Forecast 2019 - dynamic column). Variance % = Variance / Dynamic column
I hope this is clear.
Please ask if there is anything that seems unclear.