Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try this
FirstSortedValue((GJ__) ,-aggr(Sum((Jahr__)),(GJ__) ),1)
Vikas