Hi,
I have below data
DEPT |
HR |
HR |
HR |
IT |
IT |
IT |
IT |
ADMIN |
ADMIN |
I want below expected output where RecordId column value inremented by 1 based on group level of Dept
Expected output :-
DEPT | RecordId |
HR | 1 |
HR | 2 |
HR | 3 |
IT | 1 |
IT | 2 |
IT | 3 |
IT | 4 |
ADMIN | 1 |
ADMIN | 2 |
Thank you,
Solved! Go to Solution.
Thank you for your prompt reply :)