Hi @MollUser1 thank you for the additional information and @NicoleSengers for your input here!
After some digging on our end, I can also confirm that there isn’t a way to create a report that would show the Monthly recurring revenue based on what the revenue was for a specific month. A report can only be filtered by frequency based on a date property, and HubSpot reporting doesn’t support showing MRR data for a “snapshot” in time.
As @NicoleSengers already suggested, it would be great if you could post your use case in our Ideas forum so it gets visibility from our Product team. I found this Idea with a similar use and would like to encourage you to participate in the idea thread by upvoting and commenting on the post to bring it to our Product team’s attention and provide more context. You can check the Ideas Forum Users’ Guide here.
Thank you!
Mia