1 Reply Latest reply on Aug 27, 2012 7:56 AM by Jonathan Drummey

    Show companies with product X AND without product Y

    Keith Bayen

      HI,

       

      I am having trouble filtering with two conditions on a single field.  One being positive (it is there) and one being negative (it is not there).

       

      For example

      • I want to find all companies that have product X and don't have product Y (see table below):
        • I should get Company C because if has product  X (match)  and not product Y (match)  - both criteria are matched
        • Company A has product X (match)  and has product Y (no match)  - only one criteria is matched
        • Company B does not have product X (no match) and it does have product Y (no match) - so no criteria are matched

       

      Any help on how to filter this would be appreciated.

       

      Company

      Product

      Sale
      AX1,234
      AY2,345
      BY3,456
      BZ4,567
      CX5,678
      CZ6,789

       

      Thanks,

      Keith