5 Replies Latest reply on Feb 11, 2019 2:26 PM by Jim Dehner

    Ranking - defer to another measure if dimensions have same value for ranked measure

    William Murphy

      Hello all

      I am trying to figure out how to rank a set of stores based on two measures.  The rank is based on the result of measure 1, with stores ranked high to low.  However the stores regularly have the same score for measure 1, so I need to defer to a second measure in these cases.  I haven't been able to figure it out yet, hoping someone can help...

      I've attached sample workbook that demonstrates my issues with dummy data.

      Many thanks

      Will