7.7 Filter by Accumulation

 

There is a sales data table:

imagepng

To count the date when the sales volume of each person reaches 50,000, the code is as follows:

=spl("=E(?1).group(Name).new(Name,~.select@1(Sales[:0].sum()>50000).Date:Date)",A1:C22)

imagepng


esProc Desktop and Excel Processing
7.6 Accumulate data in each group
7.8 Early-terminated accumulation