Creating a report based on contingent value

Hi folks, I was wondering if you would be so kind to help me with a tricky report. 

Based on the expected date of resource engagement and expected resource use per month, I need to create a view showing how many projected resources would be engaged per project over time. 

I've gotten to the view below, but I can't figure out how to show the value correctly.

For example, 0.40 (40%) of a resource would be needed starting on 5/1/19 for a period of 3 months. This means I need to show 0.40 for three months following the start date of 5/1/19. Another resource is needed to start on 4/30/19 in the amount of 0.25 (25%) for 5 months, which means that in the first three months resource need would be totaled at 0.4+0.25=0.65 (65%).

This was way easier in Excel, when you can create a table with monthly dates across the top and formulas in values showing data bar: "For as long as the 'current date' is less than 'expected engagent date+duration of engagement' and more or equal 'expected engagement date', then resource allocation is at a constant given value "

Any ideas would be greatly appreciated!

Thank you,

T