Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want get 2nd highest value in particular column.
which function is used for that?
Please reply.
Maybe with Max(TOTAL YourExpression, 2)
Hi,
Probably use Rank() function. I.e
=Rank(YourExpression,4) = 2
Something Like this
=IF(aggr(Rank(sum(Metric Value)),Your Field)=2,Your Field)
Regards
John