Get latest value from a field

[#1]

I have a table like:

ID Type

1 a

2 a

3 b

I have a chart that displays differently depending on what the latest entry in the above table was. So it might look something like this:

if( latest(Type) = a, SUM(something), SUM(something else)

My question is how do I get that Type value into the equation? Thanks!

[#2 · Accepted solution]

Hi,

Try this:

if( Only({$<ID={'$(=max(ID))'}>} Type) = a, SUM(something), SUM(something else))

Hope this helps.

Best Regards!