Hi Sneha,

With Tableau 10 onwards you can use one common column among all the extracts as a common filter for all the sheets. For example, if all your extracts have 'Drug Name' as a common column then it can be used directly(see screenshot attached 'All using related data source').

If you are using version below Tableau 10 then it has to be done using parameters and having filter actions based on the common value.

Please attach a workbook which simulates your scenario. I will be able to explain better in that case.

Regards,

Pallavi Deshmukh

HI,

please check this Filter Data Across Multiple Data Sources

hope that helps.

Another way to do is:

1. create relationships in data sources.

2.  create all desired filters on one sheet (with any one of data source), lets call it dummy sheet.

3. use dummy sheet in all dashboards and apply filters on desired sheets.

4.  Hide dummy sheet by change layout options and keeping width and height as 1 pxl.

Hope that helps.