Hi,
I am building an Executive dashboard which have bunch of metrics out of which not all are at same level. These metrics come from multiple sources.
Eg: No. of sales is at Date>>Category level.
No. of customers is at Date level
Filers available for this dashboard are Month,Week & Category.
What I am trying to achieve is that, when a user does filtering on "Category", the metrics which are not at category level shouldn't show up.
Is there any way to achieve this?
Thanks in advance
Sampat
Hey Sampat,
While you may be able to write a calculation that allows you to hide certain items when selecting others, a simple workaround would be to build the worksheets with the data omitted then use actions to move between those worksheets, functionally hiding what you don't want to see.
-Diego
P.S. Other users may be able to help you if you post a packaged workbook with sample data.
Become a Viz Whiz on the Forums! Support the Community and master Tableau.