Hi all,
I have a bar and line chart, bars show cumulative forecast amounts for every month of the year, and I would like the line to show cumulative actuals only up to the month selected on a slicer.
Reason being, I am connecting to our accounting ledger, and there will be transactions in the current month that I am not interested in, I only want to look at the prior months (but I do want to show the future forecasts).
Does anyone know how I would do this?
Thank you
Rich
I have a bar and line chart, bars show cumulative forecast amounts for every month of the year, and I would like the line to show cumulative actuals only up to the month selected on a slicer.
Reason being, I am connecting to our accounting ledger, and there will be transactions in the current month that I am not interested in, I only want to look at the prior months (but I do want to show the future forecasts).
Does anyone know how I would do this?
Thank you
Rich