2 Replies Latest reply on Dec 6, 2017 7:19 AM by suvas.chandra

    Filter on different data sources

    suvas.chandra

      I have three different data sources. I have 10 tabs in a workbook. Four of them make one dashboard. Four sheets (four pie charts) in the dashboard are coming from two different data sources. I created a calculated field in both the data sources and trigger it in the dashboard using a parameter which works fine.

       

      I also have a common filter in all 10 worksheets. I only want to use it for the same filter value in the dashboard and other value for other dashboards. I tried to apply for selected worksheets. But it greys out while trying to select from other data sources. I also tried to use "All using related data sources". In that case, it filters all the sheets.

       

      What is the best solution ?