Cross Selling

[Arnec]

Hi there

I'm trying to do cross selling analysis based on an invoices table that has a line per invoice line:

Document Number
ItemCode
Quantity
Unit Price
Turnover

I found a fex examples here but I can't get it to work. Most of the solutions suggest creating a matrix but I don't really want to load 5 years of invoices twice in my dashboard :).

So how can I select an Itemcode from a listbox and then get an output like this:

Item 1 - sold in 5 orders - for a total quantity of 10
Item 2 - sold in 4 orders - for a total quantity of 5
... etc.

So I think it's clear I need to see all itemcodes with a value > 0 besides the one I select.

Thanks in advance

[edwin]

as item code and item name are different fields the expression will not work.  you can create 2 expressions one that assumes the selection is on item code and one that is for item name; then you make the expression conditional on which is selected:

for itemcode, use condition getselectedcount(itemcode)=1
for itemname, use condition getselectedcount(itemname)=1

 

[edwin]