Top 5 Products - Cross Sell

[exg13563]

Hey everyone! I have a need for cross sell assistance. I have a list of orders that date back to January 1, 2016. What I am looking to do is see which is the top product sold with a product when selected as a filter. Example is below:

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

So as you can see, product A is sold 3 times with product B and only once with product C. So if I selected from my filtered products "A" I want to have a result that shows me B is the product ordered most with it and it has been ordered with it 3 times.

Can anyone please provide me with the best way to create this expression as I am completely lost. Thanks in advance!

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

Count({<[Order #] =p({<Product = {"B"}>})>} [Order #])

[exg13563]

This works great! One last question before I make it solved though. Say i wanted to add 2 products like A and B, what would the expression be then?