Identify upgrade/downgrade a record in a list

Options
geet.patel
geet.patel Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi,

 

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.

 

Thanks,

Geet.

Tagged:

Categories