I think I was able to achieve what you need by using a nested table calc to calculate Previous Month open number:
Essentially, this does a "lookup" for the running sum of the count of open IDs, previous month.
Packaged workbook attached. Is this what you're looking for?
Reqs_MS.twbx 904.8 KB
Thank you Michael!
This worked perfectly for me