find the latest stage over time

Hi,

say i have this table and i want to find out the latest stage according to the time and id (in this case is "a" and "c"). what should i do? i tried last([stage]) over([id], [time]). but it is not giving me what i want

 

ID stage time
1 b 2000
1 c 2001
2 d 1999
2 a 2005

 

Thanks

 

 

(1) Answer

Login