3 Replies Latest reply on Dec 7, 2018 1:25 PM by Mavis Liu

    Pass filters  between two data sources with no join.

    priyadarshini kakarla

      I have two data sources.

      1. Summary Table
      2. Detail Table

       

       

      Without joining both the data sources can we pass the column1, Column2, Column3 filters from summary workbook to Detail Workbook or Dashboard  ( to both Report and filter) section and any filters related to Detail work book only should show relevant values based the filters passed from Summary. Is this possible?

      Note : Apply to work sheet is filtering only the report and is not reflecting in the filter section of the detail sheet.

       

      Thanks

       

      Summary:

       

      Column1

      Column2

      Column3

      Column4

      A

      HR

      YES

      400

      B

      IT

      NO

      300

      C

      BUSINESS

      YES

      500

       

       

      Detail:

       

      Column1

      Column2

      Column3

      Column4

      Column5

      A

      HR

      YES

      NCC

      200

      A

      HR

      YES

      INC

      200

      B

      IT

      NO

      NCC

      250

      B

      IT

      NO

      INC

      50

      C

      BUSINESS

      YES

      NCC

      500