Create Matrix

[Andrea92]

Hi alll

How can I create the format of this matrix attached? 

In the file input you find if a product is  been actually purchased (Yes/No) and predicted probability of purchasing the product 

Appreciate if you help me with a sample please. 

Thanks a lot 

Andrea 

[ScottE · Accepted solution]

Hi @Andrea92 

I would use two Tile Tools to create your desired range buckets for both Predicted YES and Predicted NO and then Crosstab each one to pivot the ranges to headers. That will allow you to join the YESs and NOs back together and rename headers as needed. 

Hope the attached example helps.

-Scott