Is it possible to arbitrarily reset the cumulative value of the cumulative sum function?

Get Help
1

In the following pivot table, I would like to display the sales amount by customer, department, manager, and day as cumulative values ​​for each day and month.
Is it possible to reset the accumulated value and accumulate again if the manager changes?

CumulativeSum_1
CumulativeSum_11286×732 98.7 KB

editor

CumulativeSum_2
CumulativeSum_21342×663 65.6 KB

2

Not possible, you are looking for this Should cumulative aggregations with multiple breakouts reset count/sum when values of one specific breakout columns change? · Issue #2862 · metabase/metabase · GitHub

3

got it.
Make it compatible with the SQL query.