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.