We have an Excel table for the daily sales of products:

We want to find out the date when the total daily sales amount exceeds 300,000:

=spl("=E(?1).groups(OrderDate;sum(Sales):TotalSales).select(TotalSales>300000)",A1:C2401)

esProc Desktop and Excel Processing
6.9 Take values of adjacent rows in same group (search & filter within adjacent intervals)
6.11 Use group’s aggregation value when filtering