Multiple Rolling Excel Sumifs

Hi-

I’m somewhat new to Knime and have hit a wall. I’m trying to use Knime to do what I can do in Excel. I want to calculate SUMIFS based on multiple criteria.

Criteria to use:

Customer #

Product Code

I want to calculate trailing 30 day stockouts based on Customer/Product/Date.

I’ve looked at multiple examples of group by, column aggregator or loops and I can’t seem to figure this out.

I’ve attached an example of the data as well as the desired outcome.

Thanks for any help.

Share.xlsx