1 of 1 people found this helpful
So I'd keep Year (or any date) going down the page, but would create separate columns (prior to bringing into Tableau) for Actual Sales and Budget. There are times when having a dimension for each measure is useful, but 95% of the time different measures should have their own column.
If you are unable to re-shape your data, you could try to optimise the extract (one you've created the IF calculations....IIF ([A/B] = "Actual", [Volume],NULL) ). If you have the IF statements as per the example I've just detailed (row level calculations), the optimisation process should "materialize" these calculated fields...so they are no longer calculated "on the fly"
Hope that helps