Hey,
I am trying to find a way to easily pull out items that customers purchased in common. For instance, in the example I made below I would like the results to show me that all 3 companies purchased Blue and Orange. In the actual report I am looking at 10-15 customers at a time and some customers purchase 30 different items.
I have tried to just do it manually by looking at a cross tab but the cross tab still keeps the items groups separately so I can't tell which item all customers have purchased.
Thanks for the help.
Customer Item Qty A Blue 1 A Orange 3 A Yellow 4 A Green 2 B Blue 2 B Orange 1 B Red 4 B Purple 3 C Blue 5 C Orange 3 C Black 4 C Pink 4