Market Basket Analysis - How to find frequency of Co-Occurrence.

[Anonymous]

I am stuck up in finding the co-occurrence. Please help me to solve this. See the attachment for details.

[Gysbert_Wassenaar · Accepted solution]

Try: count({<ItemCode=e(ItemCode), InvoiceNo=p({<ItemCode=p(ItemCode)>}InvoiceNo)>}DISTINCT PhoneNo)

[Anonymous]

Excellent!!! Thanks Gysbert Wassenaar.