Product Mix Charts

[manojkulkarni]

Hi All,

I need to make analysis on top n products sold against each product. How we can achieve this ?

Expected result :

When ever user buy a product1, he is buying prod6,prod7, prod4 most of the times. same way for other products.

	Prod6	Prod7	Prod4
Prod1	12	40	20
Prod2	13	35	100
Prod3	15	30	200
Prod4	16	20	245
Prod5	19	20	300

[Roop]

Hi Manoj,

a few questions for you:

• Is there a difference between a user buying prod1 buying prod6, prod7 and prod4 most of the time and a user buying prod6 vs prod1, prod7 and prod4? In other words do you know the precedence of the products sold?
• Have you got some test data?
• What should this look like at an aggregated level as it is quite easy to see at an individual user level?

Many thanks

Rupert

[robert_mika]

So you need a rank of your Prod1,Prod2, column...

and the answer for Prod1 will be

1.Prod7

2.Prod4....