Cumulative Total

Hi Ahmedx ,

Hope you are doing well.

Happy New Year !

I need futher assistance if you can help ..there is one more requirement now in which :

1) I need to show cummulative total of "Available QTY" if Avilable Date is or before today's date and if MRP Element="Stock" then only it should give me the total values and if date is of future then it should populate total  Available QTY in Future JWeek .

2) If MRP Element <> "Stock" then i need cummulative total of "Req Qty " if date is or before total else data should populate in Future week .

Please see below data set if you can help in creating this as well :

I tired the above formula which you share and added one more filter which is showing below but i am not getting my desire result .

Request you to please help asap.

Thanks,

Ashish