Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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).
Hi
Try with FirstSortedValue()
FirstSortedValue( CERT_ID, -Start_date)