2 Replies Latest reply on Jun 15, 2018 1:09 AM by Naveen B

    Calculation based on a single cell from a dimension

    Stanislav  Dyulgyarski

      Hello everyone,

       

      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!