creating local version of most recent membership level - SQL illiterate user, any tips?

Hello!

I have maxed out the help of Tessitura Support with my problem:

I want to have an Output Field that gives me the most recent membership level that is LAPSED, then another Output Field that gives me the most recent membership level that is PENDING.

I was able to create (with Tessitura Support), ONE Output Field that lists BOTH lapsed and pending memberships as most recent...this won't work as some members have lapsed memberships from an older membership organization but a pending membership in the current membership organization.

Here's what Support has said:

believe the issue here is that the view will pull the most recent memberships across membership organizations. Since the inactive membership is in a different membership organization, it is being returned by the output set because that is the most recent membership in that membership organization.
 
If you only want to return only pending and active memberships, you would need to create a local version of the view VS_ELEMENTS_MEMBERSHIP_MOST_RECENT. You could simply add "where cm.current_status_no in (2,3)" after the inner join statement in your local version of this view and reference that.

Does anyone happen to have built this custom table? If so, could that person share what was done with me? Thank you thank you!