To see the issue in the sample dataset, go to the orders table and select cumulative sum of subtotal, grouped by Created At: Month
and Product Category
. If you look at the table, you’ll see that the cumulative sum is not being performed by group – it is being performed element-wise across groups.
1 Like