Can't apply table calc filters across sheets.
Each sheet has its own table, and a table calc's calculation is specific to the table where it is getting used.
That's why you find that you need separate filters for separate sheets.
Question: From the looks of how you have it set up in your sample workbook, you might need a multi-select filter. Is that true? (Or is it just set that way in the sample, but actually you'll just be doing single-select (or ALL) in real life?)
If single select, you can control that with a parameter.
I suspect that's not what you're going to need here, though.
Yes I need a multi-select filter.
Do you think its possible to do a sheet popping trick you identified for tableau 10.4 (and above) in this situation?
Popping isn't going to do anything about the inability to apply table calcs to multiple sheets, You're going to have to have separate filters for each sheet.
Now, you CAN pop specific filters associated sheets. Essentially you'll have x-many identical-looking filters.
In the attached 10.5 example, I have exactly that happening. See Dashboard2. I have 3 sheets. In this case I have different filters for each sheet, but you'll just have to keep your identical filters straight. (Notice that I colored the titles of these filters differently. That can help you keep yours straight.)
When your user selects something from the table calc filter on your sheet 1, that selection will have to be re-selected if they swap to sheet 2.
Play with the parameter at the top of the dashboard to swap the sheets.
Pop and Swap 10.5.twbx 1.0 MB