Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI!
How can we show the largest possible value in a text object?
For example:
Customer | Sales
ABCD | 500
EFGH | 700
IJKL | 300
MNOP | 1000
so the text box should output : MNOP 1000 something like that. But when for example EFGH become 1100 for the next month, the text object will output EFGH 1100 automatically.
Thanks
I think Joey asks for - in your First Sorted Value expression :
FirstSortedValue(Customer,-Sales)& ' ' & FirstSortedValue(Sales,-Sales)
So, here - , it means that the function returns the last (highest) sorted value.