3 Replies Latest reply on May 29, 2013 9:21 AM by Chris Tsui

    Filtering Combinations and Excluding Others

    Chris Tsui

      Hi there,

       

      I am trying to create a filter which will allow me to predefine some combinations of the filter items but exclude others.

       

      My Data looks similar to:

      OrderIDType
      1Toys
      1Games
      1Appliance
      2Appliance
      3Games
      4Toys

       

      What I'd like to do is have a filter that would group "Toys and Games" together, so that when I filter for "Toys and Games" only Order 1 Comes up.

      Thus excluding all orders that don't meet this combination criteria.  I've been able to filter on Toys, or Games and it brings back 1,3 or 1,4

      If I have both types selected it brings back 1, 3, 4

       

      So it looks like the normal quick filter action is using an "OR" statement.  Is there a way to create an "AND" statement?

       

      I would have a filter for each individual type as well, but to have combinations of Types which would exclude the single values of the combination?

       

      I have been trying to get my head around Sets but I seem to be hitting a wall.

       

      Any help would be appreciated.