Double Pivot Table

Topic Labels: Extensions
493 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

0 Replies 0