13 Replies Latest reply on Aug 16, 2016 12:13 PM by Nick Zhao

    Tableau sorting --- using another measure to break the tie

    Nick Zhao

      Hello everyone,

       

      I don't know if this is possible, but here is my question. Suppose I have a dimension that I want to sort based on measure A. Measure A is producing the same value for some of the dimension values. Those are ties. Now for the ties, I would like them to be sorted based on the value of another measure B.

       

      In the attached workbook, I want the names to be sorted based on Sales initially. Notice that Cindy and Wendy have the same Sales value. So to sort Cindy and Wendy, I want it to be based on Profit. How do I achieve it?

       

      Thanks!