2 Replies Latest reply on Sep 10, 2012 3:51 AM by Robin Kennedy

    Modeling of product category affinity in sales orders

    Pavel Trejbal

      Hello,

       

      I would appreciate a little help with my problem. I have a list of sales orders (example in attached xls): each row represents product category of one product in particular sales order. It means that one order has more rows for each product category in the basket. My aim is to understant affinity of particular combinations in baskets (the most common combinations of product categories in sales orders).

       

      I wasn't able to create a symatric matrix that I need to see the most affinite combinations - distinct count of sales orders with particular combinations of categories. (in attached xls is aslo described what matrix I exactly need). I wasn't able to do this in Tableau. Has anybody experince with this problem please?

       

      Thanks much

       

      Pavel