3 Replies Latest reply on Sep 25, 2018 6:45 PM by lei.chen.0

    Filters showing "Intersection" values not "Union"

    Amit Kalia

      Please find attached snapshot


      There are two worksheets where all the mentioned filters are showing the values which are common as when I clicked ROOM as OR3, it filtered out only the data having ROOM as OR3 but when clicked on the SERVICE, it shows only the SERVICES available in first worksheets and "general" as common.
      I am looking for wayout if services will show all the services as "All, General, Cardiac, Oral Surgery, Podiatry" but "CARDIAC" is missing in the drop down.

      Please suggest the solution or workaround.Untitled.png