Hello!
I'm having a challange solving a problem for an end-user. What the user wants is more or less an analysis of what brands their customers purchase, if they purchase XX and also purchase brand YY.
Trying to put it simple; Customer purchase brand A, B and C - selecting brand A would get possible selections on brand B and C. and so on.
The result would be something like this;
BRAND1 BRAND2
A B
A C
B A
B C
C A
C B
If another customer buy items of brand C and D then the tables should be something like this
BRAND1 BRAND2
A B
A C
B A
B C
C A
C B
C D
D C
and so on.
Have tried to search for something in these lines without any success unfortunately.
Is there someone out here that has a clue on how to achieve this or has any input at all I would love to hear your ideas.
Thanks in advance!
//Niklas
