6 Replies Latest reply on Feb 4, 2012 6:58 AM by Alex Kerin

    how to find complimentary products

      I would like to find all OTHER products purchased by customers who purchased Products X, Y, Z, A, B, C.

       

      Logically, my brain is saying that I need to build a filter that is a list of CustomerIDs where those CustomerIDs are all the distinct customer IDs who purchased Products X, Y, Z, A, B, C, and then in my worksheet just have it show all Products and Revenue...etc.

       

      I haven't the foggiest idea though how to create that list of CustomerIDs to then use as a filter.

       

      Thanks.