Hi all,
I'm trying to add an index column in a query that starts from 1 and counts up and restarts at 1 for each group (TEAM in the example below). If anyone had any tips I'd be very grateful because I'm not getting very far at the moment.
TEAM GAMES GOALS PLAYER INDEX
A 0 0 1 1
A 0 0 2 2
A 1 1 3 3
A 1 2 4 4
A 3 0 5 5
A 5 3 6 6
B 1 5 1 1
B 2 0 2 2
B 3 2 3 3
B 4 0 4 4
B 4 2 5 5
Sorry for the alignment of the data there. It's the last column I'm trying to create.
Thank you in advance.
Best,
Cogency