This content has been marked as final. Show 2 replies
I am using Peek() function to flag my peek values. So according to my logic if a values occurs second time in a particular field i flag it as 1. So if A occurs twice the second record is flagged 1, 2 for B, 3 for C and so on.
I need to flag the previous record with the same flag. So the first record of where A occurs should be 1,B will be 2 and so.
What i have
What i need