Sum over specific rule

Question

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!

Sample.yxdb

grazitti_sapna · Accepted Answer

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

MilindG · Accepted Answer

Heres the solution

OllieClarke · Accepted Answer

@Ahacibo

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