Complex Authorization - How to create authorization bridge

[maxtromb]

Hi guys,

I have to create a contingency matrix like this:

My data are loaded with:

customer code; store code; sales

I want a matrix with same dimensions (store code) on rows and columns and sum (sales) or count (customer code) in the cells.

My goal is analyze the inter-channel nature of sales and customers among stores, having the diagonal with maximum value (100%) .

Thanks