Getting latest updated value in expression

[#1]

How can I get the values from the latest update in an expression?

For the data below, I'd want my chart to show for ID=1, Value=110

ID	Change Date	Value
1	1/11/2012	100
1	3/11/2012	125
1	5/11/2012	75
1	10/11/2012	90
1	20/11/2012	110

Thanks,

CJ

[Gysbert_Wassenaar · Accepted solution]

try:

aggr(FirstSortedValue(Value,-[Change Date],ID)

[#3]

can u post the qvw file for this one