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?
