Restart Rownumbering for each table group

Posted by: atalati on 3 August 2017, 3:22 pm EST

  • Posted 3 August 2017, 3:22 pm EST

    Hi friends,
    I want to start numbering back to 1 for each new group of the table. =RowNumber() continues the numbers.

    Thanks,
    -A. Talati
  • Replied 3 August 2017, 3:22 pm EST

    Hello,

    I am working on your query, I will get back to you soon.

    Thanks,
    Manpreet Kaur
  • Replied 3 August 2017, 3:22 pm EST

    Ok ...
  • Replied 3 August 2017, 3:22 pm EST

    Hello,

    The RowNumber aggregate should take in a Scope argument which tells
    it when to reset its row counting. In this case you can pass in the name
    of the group and it will reset the row count with each group instance.

    I have attached a sample report that depicts the same, please place the attached database in C drive of your system to view the attached report. Hope it will help you. Please let me know if you have any queries furrther.



    Thanks,
    Manpreet Kaur


    2012/11/RowNumberReport.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels