Hello,
I am looking to create something like a matrix, comparing values across X and Y dimensions to calculate the number of customers by category. The cell result would be an % for the other cross names of the category and for the same name of category should be the number of customers. Any suggestions ?
Scenario: Among the 100 customers who consume category 1, 33% also consume category 2 , while 45% consume the category 3.
Scenario: Among the 50 customers who consume category 2, 64% also consume category 1 , while 61% consume the category 3.
Exemple :
| |
Category 1 |
Category 2 |
Category 3 |
| Category 1 |
100 |
33% |
45% |
| Category 2 |
64% |
50 |
61% |
| Category 3 |
67% |
64% |
64 |
#Matrix
