how to write expression

[kunkumnaveen]

Hello,

        i am trying to display MAX value from a bar in a text box,what i mean is

in the above chart 1000 is the max value ,so i want to display in a TEXTBOX    name and max value which is

                  Kiran :1000 

expression i wrote in text box is = max(sum(value))

i known it is wrong

any one plz what exp do i need use to get max value in a text box

[sunny_talwar]

Try this

Max(Aggr(Sum(value), name))

[kunkumnaveen]

i got value ,is there any chance to get name of that value from     name field

[sunny_talwar · Accepted solution]

Sure, try this

FirstSortedValue(name, -Aggr(Sum(value), name))

or

FirstSortedValue(DISTINCTname, -Aggr(Sum(value), name))