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
Good morning
Here is an additional way to do this - it is more of a hack but has been useful to me in several cases (works for numeric and for alpha or combined fields)
I converted the score 1 and score 2 to a string field and then and made them all the sale length
then ranked that filed
'and it returns this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
