last value according to dimensions

[pirotfab]

Hello

I want to have the max value of the column "tps" : result = 25

I try with the attached formula that gets me a null result because I have twice a value for the same date.

do you know how to add one more criterion?

thanks

[StarinieriG]

Hi,

you could try with this expression

Aggr(Max(tps),date)

[pirotfab]

thanks for your feedback

it works for some data

I want to have the value of the field "tps" for the last production date. I do not know which expression to use

thanks

[StarinieriG]

Maybe it could work if you'll add a second field in this way "& of" 

FirstSortedValue(total tps,-date & of)

[pirotfab]

Hello,

i try with this expression, but when i add a second field, that me say : "error in expression"

thanks