Identify upgrade/downgrade a record in a list
Please go through the attached file.
here each userid has a plan and start /end date of each plan. User can upgrade/downgrade their plan. here i m looking at the solution where i can identify which is the latest plan for unique userId to consider them for the pricing.
Ex : User1 has A plan . after that he has upgraded to C plan. I want to identify that this is the latest plan to the current month.
Please help me with this.