Need to get maximum event based on crash

[praveenkumar_s]

Friends,

Need to get the maximum event which cause the crash in the KPI object as shown in the below image consists of data,

event	crash
A	10
B	5
C	2
A	15
B	2

I need an KPI object which shows that Event "A" because it has more crash (25). Any Knowledge share will be really thankfull.

[sunny_talwar · Accepted solution]

May be this

FirstSortedValue(event, -Aggr(Sum(crash), event))

[praveenkumar_s]

Thank you very much sunny, It works as expected.