Straight Table with record counter that resets

[Anonymous]

Hello,

I have a requirement in which the user wants to assign records in a straight table to variable number of individuals assigned by number. For instance, the user wants to assign the records among 5 individuals. This would need to be variable on the front-end where I would have a slider object allowing the user to define the number of individuals. In this example they have selected 5. Can you reset the rowno(total) counter?

Item	Assigned Group
1	1
2	2
3	3
4	4
5	5
6	1
7	2
8	3
9	4
10	5
11	1
12	2

[Gysbert_Wassenaar]

Mod(RowNo(Total)-1,$(vDivider))+1

[Anonymous]

=MOD(RowNo(Total)-1,$(Var3))+1

Thanks Gysbert!