Hi
I have a code which gives the name of the metric corresponding to the max value change among 20 metrics.
The code is:
=MaxString({<MTA_Change={'$(=max(MTA_Change,1))'}>}Metric)
The problem I'm facing is that if there are two metrics with the same MTA_change then the code is not working. I want the 1st metric to be shown when the rank is 1 and the second metric when the rank is 2.
Can anybody help on this?