Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sure, try this
FirstSortedValue(name, -Aggr(Sum(value), name))
or
FirstSortedValue(DISTINCTname, -Aggr(Sum(value), name))
Try this
Max(Aggr(Sum(value), name))
i got value ,is there any chance to get name of that value from name field
Sure, try this
FirstSortedValue(name, -Aggr(Sum(value), name))
or
FirstSortedValue(DISTINCTname, -Aggr(Sum(value), name))