Hi, Recently, I have a topic on cross selling. I have a order table.
Product |
OR |
Client ID |
A |
100 |
1 |
A |
200 |
2 |
A |
500 |
5 |
A |
10 |
4 |
B |
7 |
1 |
B |
8 |
3
|
C |
90 |
2 |
C |
40 |
4 |
what I'm trying to achieve is:
Store |
A |
B |
C |
A |
- |
1 |
2 |
B |
1 |
- |
1 |
C |
2 |
0 |
- |
It can be show how many clients choose the product combination. How to create a data model?