Complicated scenario with customers and products

[fredericvillemi]

Hello,

I have a quite complicated scenario with customer and products.

I have a table with the customer data and customer id.

I have a table with customer id and all the products bought by this customer.

If I select a specific product, it will filter a number of customers.

I would like to know all the other products these customers have bought.

How could I get these information ? With a set analysis ? Which one ?

Thanks

[swuehl · Accepted solution]

Set analysis could indeed help you here, something along this:

=Concat(DISTINCT {<CustomerID= p() , Product = >} Product, ', ')

[fredericvillemi]

Excellent, but now, is it possible to remove the selected Product from this list ?

thanks

[swuehl]

Maybe by using the e() function:

=Concat(DISTINCT {<CustomerID= p() , Product = e() >} Product, ', ')

[fredericvillemi]

Great, thank you, it works perfectly