Cross Matrix

[carol_wu]

Dear Masters,

I need to create a sales matrix, which have the same row header and column header, the values are # of transactions who purchased row header product category and also purchased column header product category.

I also attached the example for your references.

Thanks!

[BenMoss · Accepted solution]

Hi!

There's a few ways this can be achieved. I've created two for you.

Option A: Perform a self join on 'VisitKey' then filter out where the category is the same, then perform a cross-tab.

Option B: Use the MB-Affinity tool to create the matrix in one step. This seems to be a bit slower though.

See attached.

Ben

[carol_wu]

Wow, it worked, thanks!