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;
If another customer buy items of brand C and D then the tables should be something like this
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!