I don’t know if we yet have sufficient calendar algo tools to do this to your spec.
What follows probably isn’t exactly what you want, but maybe it will spark an idea that you can run with.
- The bottom table is the raw table where new memberships are entered chronologically.
- The top table is a View of the bottom table with a filter applied.
- monthControl: choose your months (just change with desired frequency)
I didn’t solve this all the way out or do much exceptions checking, so there are certainly mistakes in here. Just intended to give you some ideas.
I’d be very interested to see a clean solution for this.
