I would like to group data as the attached image.
whenever there is a "No" the result will be a 0.
When ever there is a "Yes" the result will be a running number (1,2,3...) for each group.
How do I implement this in a formula (or script?).
Thank you very much.
Go to Solution
Copy this expression and paste it into the Formula Editor for the Grouping column:
Row() == 1,
temp = :Y == "Yes";
:Y == "Yes" & Lag( :Y ) == "No",
:Y == "Yes", temp,
Change the name of Y to the original data column.
View solution in original post
Thank you very much