1 of 1 people found this helpful
Unfortunately, Global Filters apply only to a single data source - you can't create a "cross data-source" global filter directly.
One thing you may want to consider is using an Action Filter, however. An action filter will allow you to use a dimension value coming from one data source to filter other worksheets which use different data sources.
Here is a guide on setting an action filter: http://downloads.tableausoftware.com/quickstart/feature-guides/actions_filter.pdf
You can also search the forums using the keywords "global filter action filter multiple data sources". A bunch of people have asked similar questions, and most of the answers are better phrased than mine!
Another possible option would be to use parameters. If the fields have the same members then using the members names in the parameter and placing them in a calculated field can give you a similar effect. I have attached a sample workbook with instructions showing how this can be done.
I have reattached your workbook. First, I added Good Deeds to the parameter list so that it would appear when using the Results data source. Then, I edited the Super 1 and Super 3 calculations so that they were exactly the same as the parameters (i.e. capitalized the M's and added Good Deeds). Then, the Super calculations were edited on the Filtered shelf so that the Null box was checked, as well as the Exclude box. This makes it so that no matter what is selected in the parameter, it will show on the view without showing the Null values. The final thing I did was to Synchronize the axes (this is of course optional!).
Hope this helps!
Parameter Help File 2.twbx.zip 38.1 KB