Max value name Expression

[sibin_jacob]

Hai,

I need the physician name having max volume(physician name having the max volume based on time period and geo selection.)

How to get the  max value physician name dynamically?

Thanks,

Sibin Jacob.C

[jagan]

Hi,

Use FirstSortedValue() for this.

=FirstSortedValue(Physician, -Sum(Volume))

Hope this helps you.

Regards,

Jagan.

[sibin_jacob]

HaI Jagan,

I tried this one, but still not working!

not getting any value... I need the physician name in text object..

[jagan · Accepted solution]

Hi,

Use this expression

=FirstSortedValue(SalesMan, -Aggr(Sum(Sales), SalesMan))

It is working for me.

PFA file for the same.

Regards,

Jagan.

[sibin_jacob]

Thanks Jagan... It's working fine.....