DEV Community

Cover image for #82 — Filter by Accumulation
Judith-Excel-Sharing
Judith-Excel-Sharing

Posted on

#82 — Filter by Accumulation

Problem description & analysis:

There is a sales data table:

source table

Task: Count the dates when the sales volume of each person reaches 50,000.

Solution:

Use SPL XLL and the code is as follows:

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

The results are shown below:

result table


Download esProc Desktop for FREE and make data work for you!!! 🚀🔥⬇️

✨SPL download address: esProc Desktop FREE Download

✨Plugin Installation Method: SPL XLL Installation and Configuration

✨References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

✨YouTube FREE courses: SPL Programming

Top comments (1)

Some comments may only be visible to logged-in visitors. Sign in to view all comments.