Need Count based on group

Question

Looking to have another column with consective counts for each record based on the ID group.

For instance, Row 1 (A29GFL) would be 1, Row 2 would be 2, Row 3 would be 1.

The count is all based on location, so the first time an ID appears would be 1, the 2nd time it appears would be 2 etc...

Tyro_abc · Answer

Hi @Peace_B1

You can do this using 'Running total' very easily!

New Workflow3.yxmd

Qiu · Answer

@Peace_B1 
I also agree that Tile Tool is best fit in this situation.

Just for better understanding, here is a different approach.

1216- Peace_B1.yxmd

Christine_Assaad · Answer

Hi @Peace_B1

Please check the below. Cheers!