I have a question about creating a custom ranking. Is there a way to create a ranking field based on values in another field? For example, If the value in a field it 1 to 10 or T1 to T10, then the new ranking field would be 1, 11-20 or T11 to T20 then it would be 2, etc. The new ranking field would be a separate column so you don't lose the original values. Also note, 1 is the same as T1, 2 is the same as T2, etc. The field will only have 1 value but it can be in either format.
