showing only the latest value of a field based on a timestamp

[#1]

Hi all,

I have a set of data that contains level readings against chemical tanks.

For each tank, there are several readings, each timestamped.

I want to create a pivottable or straight table where I only show the latest reading for each tank. The timestamp of the latest reading will be different for each tank as the reading frequency is not consistant.

Any ideas as to what expression to use?

Thanks
Dan

[Miguel_Angel_Baeyens · Accepted solution]

Hello Dan,

FirstSortedValue() function may help you (untested)

FirstSortedValue(Reading, Timestamp)

Is that what you are looking for?

[#3]

Works great - thanks!