10 Replies Latest reply on Sep 13, 2017 4:24 AM by Kalyan Allam

    Help with filtering

    kristian.jarvenpaa

      Hi!

       

      I have a problem that I just can't figure out and would appreciate any help.

       

      Given these rows:

       

      Row
      ID
      Product
      Sum
      11A12
      22B43
      32A23
      42A443
      52C32
      63B12
      71C3

       

      I'd like to build a filter that would only leave rows of IDs that have products A and B. So first find all ID's that have at least one row with product A and at least one row with product B and include ALL the rows of those IDs

       

      In this example I'd like to end up with rows 2,3,4 and 5 since ID 2 is the only one with both products.

       

      Eventually, I'd like to answer questions like what is the total sum of IDs who have product A and B.

       

      Was this unclear enough? Let me know if you need more clarification.