Forum Discussion
Solved
Cumulative that reset
Hey everyone, I need to sum a cumulative way that will stop at some point and reset the sum: Example: Product idorder repeat new column * Product A 1 ...
I don't know what that means. Both orders 1 and 3 have two products. why can order 2 not have two products?
Just can't be the same product, a order can have a lot of products
What is the expected outcome for
Product idorder
Product A 1 Product B 1 Product A 2 Product C 2 Product A 3 Product C 3 Product C 4 Product A 5 Product A 6 Product idorder New column
Product A 1 0
Product B 1 0
Product A 2 1
Product C 2 0
Product A 3 2
Product C 3 1
Product C 4 2
Product A 5 0
Product A 6 1