How to pick most recent record

[#1]

Hi

I have a scenario where an order can have multiple certificates, but in the result set I wish to see most recent cert corresponding to the order based on start_date. Please see data below for 2 orders, I should be able to pick the highlighted data.

Order_ID	CERT_ID	Start_date
12345	567	09/01/2013
12345	568	09/02/2013
12345	569	09/03/2013
56789	678	09/07/2013
56789	675	09/07/2013

Please help. Thank you Much in advance

[swuehl]

Create a chart with dimension Order_ID and as expression

=FirstSortedValue( CERT_ID, -Start_date)

where start date must have a numeric representation (i.e. like a QV date as a dual value).

[MayilVahanan]

Hi

Try with FirstSortedValue()

FirstSortedValue( CERT_ID, -Start_date)