I think we need to do some data clean up here first as below.
1. Please remove aggregate data containing ALL and leave only granular data in the data set. This would imply that all rows are at the same grain.
2. Please alter the structure of the data to have the following columns - OG, BU, Market, Metric 1, Metric 2, Metric 3.
When you feed the above, tableau can do a much better job and the above output can be made in seconds.
Let me know if you need further help.
Not certain I fully understand what you need but look at the attached T-10.1 workbook
Dose the action on the dashboard do what you want?
Let me know if this meets the need
You ask about downloading data - yes that is possible by going to Worksheet and export - crosstab to excel
Sample_Data.twbx 53.2 KB
Good Morning Jim,
Thanks for the prompt reply, yes this is very similar to what I was trying to achieve. Now I can present the same to my seniors.
Glad I could help you out
Feel free to contact me if you have questions in the future
Thanks for the badge - always appreciated