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


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1654737567626
https://c.scudata.com/article/1654825822056