Hi Everyone.
I have seen this being lauded as Tableau 10s new features, but I can't seem to make it work.
I keep seeing access to the "filter all related datasource" capability, but it doesn't seem to function.
I have a list of Country Codes and want to use this as a secondary datasource in two worksheets with different primary datasources.
I want to filter what is in the primary datasource with what is in the secondary datasource.
The idea is that the user can setup and maintain a list of Country Codes they want to watch which will filter the row level detail on the worksheets with the primary data.
Even if I use a filter with "All using this datasource" it doesn't appear to work either.
I cannot for the life of me get this to work.
I'll attach a sample workbook.
Hi Dan,
I've got a different take than Hannah on this problem... What I see is that you're trying to use Country Name to filter A and B when the field that exists across the sources is actually the Country/Country Code field.
Unfortunately cross data source filters don't allow us to do this sort of indirection so far as I can tell - the field that we're using to filter has to exist in each source. This is different from regular Tableau data blending that would allow us to do this sort of filtering (but only to filter a single primary, not multiple).
Some options are:
1. Use Tableau 10's cross-data source joins to join the CountryList source to each of the other sources, then you'd have the Country Name field in each source and could use the CountryList source for the cross-data source filter.
2. Use a parameter & calculated fields in each source to do the filtering.
3. Do the necessary data prep to have a single data source.
Jonathan
