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

[#1]

Hello,

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?

[#2 · Accepted solution]

Sum({<Product.Name=,Customer.Name=P(Customer.Name)>} LineItem.Qty)

That should get any product purchased by any customer who matches the selection criteria. I guessed at the Product.Name field name, so you may need to change that one.

[#3]

Perfect, thanks!