1 of 1 people found this helpful
Yes I'm pretty sure this is possible. I think all you need are some "kill" actions, so when someone clicks one of the selectors it, not only selects/shows the desired sheet, but also kills (collapses) the other ones.
I answered a question here with a similar problem
Hope that helps.
Can we capture the Action to a calculated field?
For ex:if we click on any of the sales sheet, we could provide a number 1 Or Letter S and
can use these values in calculated field to get displayed the corresponding values.If User click on any of Profit sheets ,we could pass value 2 or Letter "P" to identify the action as Profit and then can further use it in a calculation?
Is that Possible?
Hope you had a nice end of year break.
Not sure ...it all depends by what you mean by "pass the value". We can set up the dummy field (where I've used 1One and/or 0Zero) to be "S" and "P" and we can add that level to the respective sheets, so we send the value "S" or "P" depending on which sheet is selected. Beyond that you'll need to give me a bit more detail on how you want this value to be used in a calculation. We'er passing the value as a filter, and not setting a value, so we couldn't do something like
IF [Field] = "S" then [do something] else [do something else] end
If you can give me an example of the calculation you want to use, I can have a think (it might be you need 2 different calculations on 2 different sheets, and the filter determines which one is shown)
Simon,Yes I was thinking about something like a field which can be include in the calculation.
My idea was to capture the value from action say for example "S" if we click on sales sheet and then say if action(s) then total(sales) elseif action [P] then total(profit).
In that case I would be able to use only one sheet instead of using 2 sheets .
But hiding sheets works fine for me.I hope tableau's next version would be able to capture the values in actions.
So yes we could do this by reshaping the data, so "Measure Names" is a real dimension, and so could get passed via Actions Or yes if Tableau can make (the generated) "measure names" more of a real dimension that would do the trick.