Create a number sequent in a period column.
Best Answer
-
To ensure that it resets each year add another line item dimensioned by year period.
Adjust the formula; RANK(1,ASCENDING,SEQUENTIAL,TRUE,Yea [Line Item])
1
Answers
-
Use RANK(1, ascending, sequential, true)
1