I’ve got a table of monthly subscription transactions, and I’m trying to find a way to report on new and lapsed subscriptions.

New subscriptions would be a list of new subscriptions from the previous month

Lapsed subsciptions would be a list of subscriptions that had transactions two months ago, but did not have a transaction last month.

Currently I have to download the table to Excel, run a pivot table in excel of subscriptions along with min and max month for that subscription and then do a second pivot table of months and a count of subscriptions with min month equal to that month (for new subscriptions) and a pivot table of months with a count of subscriptions with max month equal to that month.

Is there some way to do this via a pivot table or chart in Airtable?