get name of maxvalue into title

[#1]

Hi community,

once again i have a little question for u.

i have this measure

Max(aggr(Sum({$<[booking dis]={'stolen'}>}amount_SW)/Sum(amount_TS),articlename))

and i want to show the articlename of the max in the titel.

Can some one help me.Thanks in advance.

-Eric

[sunny_talwar · Accepted solution]

May be this:

FirstSortedValue(articlename, -Aggr(Sum({$<[booking dis]={'stolen'}>}amount_SW)/Sum(amount_TS), articlename))

[swuehl]

Maybe

=FirstSortedValue(DISTINCT articlename, -aggr( Sum({$<[booking dis]={'stolen'}>}amount_SW)/Sum(amount_TS),articlename) )

[#4]

Thanks to both of u,

made a stupid mistake sorry.

I had the same idea with the first sorted but i struggled with syntax.

can i delete the - infront of aggr to get the min or how can i get the min name?

Thanks

-Eric