I have a list of incidents, with tow major events: Open & Reassignment. The enddate of each event is the respective startdate of the following major event. Between these major events, other "Sub events" happening. In column " ID Open & Reassignment" I need the ID of the previous major event.
I tried many approaches but nothing worked so far.