variable is not getting the firstsortedvalue

[yacine]

I want to get the value (string) of column 1 (GJ__)  that corresponds to the maximum value (integer) of column 2 (Jahr__)

i tried using firstsortedvalue() in this way:

let aktuellesjahr = firstsortedvalue( GJ_, -[Jahr__]);

table1: load
GJ_,
if(GJ_ = '$(aktuellesjahr)' ,'yes', 'no') as "current year",

...

this doesn't seem to be working. Theres surely somthing wrong in it but i could find it out. Thank you in advance.

[vikasmahajan]

try this

FirstSortedValue((GJ__) ,-aggr(Sum((Jahr__)),(GJ__) ),1)

Vikas