Report by date with repeating value till end date

I'm trying to display a report on monthly recurring revenue (MRR).

I have a subscription object that has a subscription start date and a subscription price. I enabled repeat and end date for use with a calendar and selected ignore time for the date field.

When i try to display the data it doesn't repeat the calculation for each month. It shows the total subscription price for all the subscriptions that start on the same month.

Can anyone help?

I've grouped the dates by month in the report and selected to display from the 1st month till the 12th Month for that year.