Cross selling

[#1]

Hi everyone !

I want to create a table which shows the second product has bought by customers according to the first product.

Example :

Transaction 1 - Product A

Transaction 1 - Product B

Transaction 2 - Product A

Transaction 3 - Product B

Transaction 4 - Product C

Transaction 5 - Product C

Transaction 5 - Product A

Transaction 6 - Product C

Transaction 6 - Product A

Result :

Product A - Product B - Total 1

Product A - Product C - Total 2

Product B - Product A - Total 1

Product C - Product A - Total 2

Is it possible ?

Thanks

[#2 · Accepted solution]

Using "And mode"

[#3]

Hi

Would you please elaborate?

Thanks,

Aji Paul.