This can generally be achieved with one or more parameters coupled with one or more calculated fields. Can you attach a packaged workbook? See Shawn Wallwork's advice on getting a satisfactory answer to your forum question on his article: So Your Question Didn't Get Answered....
In the meantime, this might help spur your creative juices regarding what you can do with parameters: Using Parameters | Tableau Software
Mark thanks for referring folks to the So your Question.... guide. Just wanted to mention this is a group effort. I posted the original but many others have edited and added to it, notably Jonathan, Andy, Josh and others. You're also welcome edit/add to it if you have other tips.
Thanks for the reply Mark!
Actually I am wondering if there is another way other than using parameter to achieve this. We have a lot of data and we would have a lot of elements in the parameter - not easy to maintain and I believe by using parameter, the performance might be degraded. Also we have a lot of users and for each of them, what's shown in the parameter filter (if I understand you correctly: your suggestion is to put this parameter as a filter) differs. This is not ideal to us.
Please do let me know if I misunderstand you. Unfortunately I am afraid for now I would not want to distribute our workbook. But I would try to make a sample later.
Any other ideas?
1 of 1 people found this helpful
I set up a couple of options in the attached. Tableau isn't by nature set up to do an OR filter, so the only thing I could come up with that fakes an OR filter is a hack using separate secondary data sources to filter the primary, while keeping a Null filter selected. This is the "data blend for OR filter" worksheet, and is not really workable, I put it together more as a conceptual work.
There is an alternative, though, and that's to go back to your original data that is coming in with the pre-aggregations. Rather than trying to limit the filter options, how about making the computations smart enough to ignore including the pre-aggregated _Overall totals when a user has selected other values? I set an example up in the attached that uses a nested table calculation to flag whether there are detail rows selected, and if so, the _Overall row for that column A is not included in the sum of C. Because you didn't provide a packaged workbook with sample data or more detail on the desired view, I had to make some guesses, if this seems like it could meet your needs and you need more help please mock something up, thanks!