Problems with accumulating in stacked column chart

Hi Phil_Seamark

I want the visual to show me the value of the opportunities from the Date of First Delivery and until 2021. So if I have an opportunity with a DOFD on the 1st of january 2018 I want this to continue until the 31st of december 2021. Then i have another opprtunity starting the 31st of january 2018. This opportunity should then be added to the first opportunity on this date.

I want the visual to show the calculated value pr day from DOFD to the 31st of December 2021. This also means, that I want the visual so summarize the data when i move up a level. E.g. If I have a value of $100 pr day, in the month of January and I look only at the month of January, I want to see the value of $100 for each day. But if I move up a level and to where I can see all of my months of a year, and not just the days, I want the visual to display $3100 on the month of January ($100*31days=$3100) 

Right now I do not wish the data to reset each year :)