I want to know how much new revenue I generated from a membership product in a given month (say month X)

Right now, in the Purchases tab, I can filter by product and "Purchased at → Month X" but unless I record it on the first day of the next month, the "Received" will show me the total cumulative revenue until the date checked (ie, it includes all renewal amounts).

And in the Receipts tab, I can filter by product and "Paid at → Month X" but it will show payments from the purchases at all times (ie, I can't filter "new" purchases in Month X)