Hi, Is it possible to dynamically change the column metrics (calculated fields) based on a filter selection in tableau? Solution that can be achieved through a case statement does not really solve my purpose as the number of metrics and their headers also has to change accordingly. Also, show/Hide reports with wildcard match is not efficient ( I have around 20 reports)
Only way I could do this is, after selecting the sub-type filter; users must be forced to select related metrics from the choose metrics filer. Please let me know if there is other better way to handle this situation.
It would be much easier to help find a solution if we had a packaged workbook with sample data that we could take a look at. If you have sensitive data, check out Anonymize your Tableau Package Data for Sharing. Otherwise, this thread may be helpful: