1 of 1 people found this helpful
So one way would be to reshape your data, so that your measures go down the page as a dimension (so you'd get a "real" measures name dimension, not the pseudo-dimension Tableau creates, which can't be used in actions)
An alternative to this would be to use "Trigger Driven Sheet Swaps" (here's a link to the general idea Sheet Swap with Action Filters...the simple version! )
So in your version I worked up just 2 of your BANs. I need to create a sheet for each BAN, and then put them together in a dashboard...now we have total control over padding and borders we can set these to zero and have the sheets look like one!)
I then created 2 dimensions (1One and 0Zero), which are just the number 1 and 0, respectively...these will be use to show the correct trend.
I then need to create 2 actions for each BAN....one to show the one we want, and another to "kill" the others.
So I set up 2 for Sales;
This one sends 1One to 0Zero on the Qty Trend...which kills it (1 can't equal 0!)
An another to show the Sales one (this undoes any 1=0 kill actions)
I then set up similar ones for Quantity.
So a bit of work to set up, but it's a trick I use a lot (especially Tablet/Phone dashboards where you want button type actions and have limited screen space)
Hope that helps and makes sense?
Thanks for the quick response and the solution.
I think that this will work for me, i just have a bit of setting up to do initially as you say but the end result will be as required.