firstsortedvalue value date descending number ascending

[curiousfellow]

I have a table with for example an employeename, dates, and sales_per_customer

Now I want to find for every employee, the highest date and within that date the lowest sales_per_customer.

So I tried firstsortedvalue(employeename, -date, sales_per_customer) but apparently only one sort_weight is allowed ?

So is there another way to achieve this, without having to create a lot of temporary tables 🙂

[sunny_talwar]

May be this

FirstSortedValue(employeename, -date + (sales_per_customer/1E10))

[curiousfellow · Accepted solution]

I made a simple example, in real life my second field is a string. Perhaps I can do something with the lenght of the string.

Thank you for giving a direction

[sunny_talwar]

You can do length or rank of string....