I recently tumbled on to this question in a recent interview and we can consider Sample - SuperStore as a baseline for this discussion.
He wants to display a certain measures in certain year and few others in other years.
So, in the context of Sample - SuperStore, say in 2014 we only want to display Discount, Number of Records and Profit.
In 2015 we want to display Sales and Profit. In 2016 Profit Ratio and Quantity and in 2017 Profit, Profit ratio and Sales.
Any idea how can we do it?
Not exactly sure what 'hiding' means, but a calculated field might be able to help. Based on the year, you either show a measure or NULL.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...