Multiple Sorting and Calculating from previous row

Hi All,   I am trying to track the occurance of a particular status in my data set over time (per unique ID).    I have been reading a few pages and am worried it is not possible to do what I am ...