Cross Sell...?

[#1]

Hi all

I need your help for a specific requirement where I believe set analysis is the answer.

What i need is a way to see how many items that has been sold together with another item (based on the transactionID).

In a table it would look like this:

Item: Items on transactions:

TV 116

DVD 278

Stereo 84

The purpose is to see in what items the salespersonel is available to sell additional items. Has anyone done anything like that?

I can see what items that are sold together with each item using:

sum( {$<TransactionID= P({1<ItemID={ItemID}>} TransactionID),ItemID={"*"}-{ItemID}>} Units)

Thanks for your help.

/Martin