How to increment row number starting from Zero

[thd-data-analyst]

Hello,

I need to assign row number to groups of data in a table. My table is like this:

Product	Category	Attribute	Value
100123	Cat1	Att1	Blue
100123	Cat1	Att1	Green
100123	Cat1	Att1	Yellow
100123	Cat1	Att1	Orange
100127	Cat2	Att1	Power Wash
100127	Cat2	Att1	Oil Change
100127	Cat2	Att1	Fluids Top-up
100130	Cat1	Att2	Stainless Steel Drum
100130	Cat1	Att2	Programable Timer
100130	Cat1	Att2	Fuzzy Logic
100130	Cat1	Att2	Auto Shut-off
100130	Cat1	Att2	Water Saving
100135	Cat2	Att1	Power Wash
100135	Cat2	Att1	Oil Change

I need a new Position column that starts from zero and increments by 1 for each item in the group. I was able to add the increments using a Multi-row formula, but I don't know to start the numbering from zero. Can anyone suggest how I can do that?

I have attached my workflow to the question.

[atcodedog05]

Hi @thd-data-analyst 

You give a look at Tile tool it's tile sequence gives a similar effect as record ID on grouby when configured to unique value

https://help.alteryx.com/current/designer/tile-tool

Hope this helps 🙂

[thd-data-analyst]

Thank you @atcodedog05  and @TheOC . You guys rock. 🕺

[atcodedog05]

Happy to help 🙂 @thd-data-analyst 

Cheers and Happy Analyzing 😀