I have a table that lists our employees. Among other fields I have a BeganDate and a EndedDate (the EndedDate field would be blank for everyone currently employed).
What I want to achieve is a list grouped/sorted by YYYY-MM and how many employees we had employed during that year-month.
The date range extends back to 2013, and my first attempt on this was to create a list with all the dates since then. Further I was going to link all the employees to all the dates (easy enough), but at that point my experiment stopped. I couldn’t realize how to solve this with rollups and with more employees being polled in all with different dates.
Not sure if it matters but my list of names is about 70.
Does anyone have an idea on how to solve this? Ideally with the least amount of new records created as possible.