find the latest stage over time


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





(1) Answer