Recommendation Measure Needed

Hi All,

I have two tables 'Orders' and 'OrderItems' which looks like this:

ORDER TABLE

Order ID | Amount

1                $x

2                $x

3                $x

ORDERITEMS TABLES

Trx ID | Order ID | Item Name | Amount

1             1               Chicken          $x

2             1               Coleslaw         $x

3             1               Pop                 $x

4             2               Chicken           $x

5             2               Pop                 $x

6             2               Fruit                 $x

I want to build a little algorithim which suggests by item that People who buys X Item often buys Y item as well. So far example in above data I want to add a tooltip to item listing in report so when somebody hover over Chicken it says "People who buys chicken often buy Pop".

Thanks for your help.

Regards,

M