community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Cross Matrix

Highlighted
Alteryx Partner

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!

output.JPG

Alteryx Certified Partner
Alteryx Certified Partner

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.

 

2018-07-31_16-51-14.png

 

See attached.

 

Ben

Alteryx Partner

Wow, it worked, thanks!

Labels