how to show highest sales city Name in text object

[#1]

hi guyys,

i m able to get highest sale value in text --- =max(Aggr(sum(Sales),City)) ... But i want to show the Name of the City

right now its showing a Highest sales Amount.. kinldy inform how to do this

[sunny_talwar]

May be try this:

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

[#3]

Thankss

[alexandros17]

Write

FirstSortedValue(City, -Aggr(Sum(Sales),City))

let me know

[sunny_talwar]

Did it work??

[alexandros17]

Do as sunindia wrote ... it works