Creating User Cohorts Based on Last Subscription Status Event

Hi, is there any way to create a cohort based on the last instance of certain event. we have an event that tracks transition of the user between different subscription statues - free, trial and paid. the event has two properties, current_plan and new_plan, that tracks the transition. for example when user signs for the trial, the event fires with current_plan as free and new plan as trial. i want to create a cohort of users based on the last instance of the event. for example, last instance of the event with new_plan=paid means active paid users.