My business charges a monthly subscription fee throughout the life an an agreement. For example, someone signs an agreement to participate from 06/01/2020 to 12/31/2021 and they pay $500 per month.
I am new to AirTable. I have the monthly amount they are paying associated with the client and I have the start date of the agreement and the end date of the agreement. I need to be able to create a table or a view that shows me the total revenue for all clients for a given time period (i.e. revenue every month into the future).