Calculate sum of data and use this sum in following calculations

[#1]

Hi everybody!

I have source table

User set period (I marked it green in source table - from 01/06 to 01/12). Red period is evaluated automatically.

I need -

1. evaluate sum of red period (210 in example)

2. evaluate amount from green period + sum of red period.

Expected result -

Is it possible?

Thanx.