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!