Create a number sequent in a period column.

AtzdGr8
AtzdGr8
edited April 30 in Modeling

Hi everyone. what is the formula on adding a number sequent in one column like 1,2,3,4,5 etc. i tried RANKCUMULATE but it returns all 1. by the way this result was already filtered. thank you.

image.png

Best Answer

  • ChrisAHeathcote
    ChrisAHeathcote
    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])

Answers

Categories