1 Reply Latest reply on Feb 2, 2017 4:46 PM by Shinichiro Murakami

    How to identify orders that include both of two specific items?

    Andrew Cureton

      Take for example my data is all line-level order data, meaning each row represents one line of an order. There is one product per line, so if I have a dimension for order number, and another for products A, B, & C. It's typical for each of these products to be ordered independently from one another, but I'm interested in orders that include both A and B.

       

      Order Number
      Product
      1A
      2A
      2B
      3A
      4C
      4B

       

      How would I pull out order number 2?