The problem with this solution is that it takes a snapshot of the data at that point in time. This means that it won't update when the new data comes in. I would also like to be able to see these on the same chart - rather than on separate sheets, but this is not a requirement so I can do without it.
The business question would be: What was the forecast for month x, and what did we actually achieve in that month? The picture below shows what I would like to create (made in Excel).
Does anyone know if this is possible in Tableau and how to do it? To have a live, updating forecast vs actual chart / table? The superstore data can be used as an example workbook as it is basically the same.