2 Replies Latest reply: Jan 10, 2011 5:50 PM by jvoorhis RSS

    I'm sure I've seen this, but.. Selecting product A, seeing what other product those who bought it also purchased


      Say I have Customers, Orders, and LineItems Tables.

      I build a simple straight chart that shows Customer.Name and LineItems.ProductName as Dimensions and an expression of Sum(LineItem.Qty)

      What I need: I select a Product Name(s) and I want another Table to show the the other products that were purchased by the customers that product, with a sum on the quanity of each.

      Any ideas?