This content has been marked as final.
Show 1 reply
-
1. Re: The most effective way in terms of performance to work with such data
Simon RuncAug 29, 2017 1:25 AM (in response to Kemal Gürler)
1 of 1 people found this helpfulhi Kemal,
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