Need Help with aggr function

[pgarcia75]

Hi all

I need help on the function aggr

The expression "max (Aggr (count ([Type_Incident]), [Type_Incident]))" returns the maximum number of count([Type_Incident])

of the dimension [Type_Incident]

.

I would now find the [type_Incident], which corresponds to the max max (Aggr (count ([Type_Incident]), [Type_Incident]))?

Thank you for your help

P

[pat_agen · Accepted solution]

hi,

try something like this

=only(if(aggr(rank(count (Type_incident)),Type_incident)=1,Type_incident))

[pgarcia75]

Thanks, it's working

P