Give each row a sequential number depending on several fields
I'm looking to number my rows, based on values of three fields.
The data looks like the following: I have UserId, VisitId, and HitNumber. However, HitNumber isn't always sequential, and I'd like to have another field that does give each row a sequential number, but only within the confines of UserId and VisitId.
I want to create the field PVNumber, that will give each UserId + VisitId + HitNumber combination a sequential number as shown below: