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
 
					
				
		
 swuehl
		
			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
		
			MayilVahanan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi
Try with FirstSortedValue()
FirstSortedValue( CERT_ID, -Start_date)
