1 Reply Latest reply on Dec 10, 2012 6:26 AM by Alex Kerin

    How to change the filter values of second sheet(datasource 2) by changing filter in the first sheet(datasource1)

    Sumalatha Balasubramanian

      Hi,

       

      I have 2 sheets in a dashboard, each pointing to two different data sources. Couple of fields are common in both the data sources.

      The first sheet is pointing to a mapping table that has static data in it. This sheet has 2 filters

      Second sheet is pointing to a data table. this sheet has 4 filters and chart.

       

      By changing the filter value in the first sheet, filters of second sheet need to be changed.

      Is there any way to do it without merging these 2 datasources?