Get second max value of a text value

[SudharshanK]

How to get the second max value of a string? I am able to get the maximum value of selected values through this function:

maxstring(total <Field>)

[RafaelBarrios]

Hi @SudharshanK 

I guess you could try 

maxstring({< field=-{“$(=maxstring(total field))”} >}field)

hope this helps.

best,

[SudharshanK]

I tried this its not working

[RafaelBarrios]

hi @SudharshanK 

I put the '-' sign in the wrong place

should be:

maxstring({< field-={"$(=maxstring(total field))"} >}field)

for example, if i dont have any selection

and on selection

hope this one works.

best,

[SudharshanK]

The end users did not want the metrics for the previous months so I did not have to do this calculation after all. Thanks for helping me out.

[RafaelBarrios]

Well, that happens many times

If the proposed solution solves the original problem, it would be nice if you accept it as a solution.

Best,