Forum Discussion

sajidmansoorali's avatar
sajidmansoorali
Helper I
8 years ago
Solved

Row Number on Table(Visual)

I want to show row numbers on any Table Visual, just like in excel row number.
BalaVenuGopal's avatar
BalaVenuGopal
Resolver I
8 years ago

Hi sajidmansoorali ,

 

Go to Edit Queris --> Add Column tab -- > index column -->From 1 

this will add index column and change data type to Whole Number .

Go to report add this index column.

 

Please mark as solution if this works for you .

 

Thanks

  • sajidmansoorali's avatar
    sajidmansoorali
    Helper I
    8 years ago

    thanks for your reply, but i need serial on "Visual Table"

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I want to know exactly like you. My question is same of you.

      • tex628's avatar
        tex628
        Community Champion
        5 years ago

        The matrix and table visuals simply does not currently offer a dynamic row number. But if you happen to know that your table or matrix always will be sorted the same way, you can create ranking measure that will be able to act as a dynamic row number. 

        This will only work if the sorting direction and column remains the same, but should work with slicers if you adapt the code correctly. There are methods to prevent the user from changing sorting column and direction, so if combined it could prove to be a good solution. 

        I've attached a file as an example. 

        Br,
        J