4 Replies Latest reply on Apr 3, 2018 8:59 AM by Suresh Martha

    Cascading Filter

    Suresh Martha

      Hi All,

       

      I have a need where in one dashboard one of the sheet should filter on both parent and child filter and while the other worksheet should only filter on the parent filter. I have used two quick filters in the attached workbook (State, City). First worksheet is filtered on City and State and works fine where as the 2nd worksheet is only filtered on State. The problem I run into is when I select "Boston" in the city filter although the State filter shows MA, the 2nd worksheet doesn't get filtered by MA data. The filter dropdown works fine as it is set to show "Only Relevant Values" but the worksheet is not. Is there a way to make this work? Thanks in Advance.

       

      Thanks,

      Suresh Martha