Assigning Incremental Counter

[alibink]

I have looked around in the community posts but couldn't find this solution. 

I have a dataset like 

Account
A
A
A
A
A
A
A
A
A
A
A
A
A
B
B
B
C
C
C
C
C
D
D
D
D
D
D
D
D
D
D
E
E

and I want an output like the following

Account	Required Field
A	1
A	2
A	3
A	4
A	5
A	1
A	2
A	3
A	4
A	5
A	1
A	2
A	3
B	1
B	2
B	3
C	1
C	2
C	3
C	4
C	5
D	1
D	2
D	3
D	4
D	5
D	1
D	2
D	3
D	4
D	5
D	1
E	1
E	2

Criteria: 

The Counter in the 'Required Field' gets reset after:

1. On the 6th Record of Same Account or if 
2. The Account Changes before the counter could reach to 5

Any help would be much appreciated. 

I saw similar solution where the requirement of people was just to reset the number based on value in Account and it could be done using Unique Value of Tile Tool but here we have another criteria to forcefully restart numbering if counter reaches 5. I am attaching my incomplete workflow as well if that helps? Please note that in the attached workflow, I have setup the reset counter value at 7 not 5. 

[DanM]

@alibink  check this tool out https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p...

you also have samples of this tool and how to create what you want under the Help in Designer. You can also take an interactive lesson on how to use the tool as well. It is a function that you will create to basically say by group start with 1 and add 1 until the group ends.

[binuacs]

@alibink One way of doing this with the Tile Tool

[Qiu]

@alibink 
One way to use Multi-row formula as below.