1 Reply Latest reply on Dec 19, 2016 2:45 PM by diego.medrano

    Dynamic Filter, Multiple Sheets

    Nik Rao

      Hi,

       

      I have two data sources DS-1, DS-2 as seen below.

      DS-1.JPGDS-2.JPG

       

      I used them as individual seperate connections to generate two seperate reports(Sheet1 and 2) and have them on one Dashboard.

       

      Dashboard.JPG

       

      The first report -1 has two filters "Left Entity" and "Right Entity"

      The second report -2 has the filter "Entity"

       

      I have two question here.

      1) How can I set a default value for filter "Right Entity" based on the value of filter "Left Entity"

      2) Is there anyway I can link the filter "Entity" to the selections of the first two filters? Ex: if A & C are selected, "Entity" should only have A & C selected.

       

      Appreciate all the help and advice I can get here. Thank You.

       

      I have also attached the workbook.

       

      Regards,
      Nik