This content has been marked as final. Show 2 replies
I am trying to create a cross selling matrix in Tableau 10.4.3. I have loaded data for a single store and my final goal is to see an estimate of how we are performing on cross selling. The measure that I want to show in the matrix would be the number of sold pieces, divided by the number of receipts for a specific product group. However I cannot figure out how to divide the numbers form the row Bra_Pieces by the number of receipts in column bra.
I have tried using "if" statements, I have tried using the "fixed" function but nothing seems to work. Attached you will find a twbx.
It would be amazing if you can help!
Thank you in advance!