Jump to content

Recommended Posts

Posted

I am trying to give dynamic row number to the data . I have used limit expressions to get some desired output but i want the number to be displayed numerically. For example: in place of 96,97 ... I want to show1,2,3.....

Is there any solution for it.

  • 4 weeks later...
Posted

You could create a new calculated column to re-rank the rows based on your limiting expression. For example, this will re-rank them based on the table row ID (but you could use the column shown in your screenshot).

case when then Rank(RowId()) end

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...