Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following table
I want to have the first value by ITEM in all lines of the table.
When i write the expression FirstSortedValue(PRICE,ITEM_ID) in the last line that the price is different does not work to give me also the price 1,52 . How can i achieve this ?
Thank you in advanced.
I found the solution with the expression
aggr(nodistinct FirstSortedValue(PRICE,Rank,1),ITEM_ID)
In the script i rank the lines by ITEM and DATE