Welcome to the community, @Roy_Selbach! :grinning_face_with_big_eyes: You say that you have a list (guessing in a table) of customers, but you didn’t describe very clearly where/how you want to see and interact with this aggregation of revenue and active customer data. One option would be to have a second table where each record represents a single month (I’ll call this the [Months] table). Customers would be linked to the month records that correspond to their active range. With that done, each month record would be able to show a summary of all revenue from the linked customers, as well as a total count of those customers.
The tricky part is figuring out a way to automatically create those links between customers and months. I wasn’t sure if it was possible without resorting to code (and I do love me some code!), but I found a way to make it work with a couple of no-code automations and a handful of helper fields. I don’t have time at the moment to type out the setup of the system, but here’s a look at how it works:
If this will work for your use case, let me know and I’ll work on writing out the details of how to put it all together.