Sum over specific rule

[Ahacibo]

Hello, I've looked around and haven't found something similar to my need, so hoping someone can assist.

Based on sample data loaded, I am looking for a way to calculate a sum of produced orders for each field per product ID for 4 days (4 is a variable).

The picture shows the desired values in the column "4 days sum".

Thanks in advance!

[grazitti_sapna · Accepted solution]

@Ahacibo , Please find the solution attached you just need to use Multi-Row Formula

[MilindG · Accepted solution]

Heres the solution

[OllieClarke · Accepted solution]

@Ahacibo 

Here's how I'd do this: If you want to change the number of days, you can update the formula tool

[Ahacibo]

Thank you all for the solutions sent.