Help with Date Ranges


I have a list of budgets that extend over multi years. I used the date by range option so I now have a single budget item, and the range is now over multi years.
Problem is, if I sum the records by date, if does not recognise that the budget should be registered for each year.

Does anyone have any advice on how best to work with the date range, or do I need to change this to a normal date and repeat the entry for each year.