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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Cross Matrix

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