Adding a serial number in pivot table

[fj11]

I want to add serial number as first column(dimension) in my pivot table. I tired using RowNo() but it doesnt give me expected results because i sort the table on a different measure and adding rowno() , removes the sorting done with a different measure.

Any suggestions on how do i keep the sorting in place as well as add serial no as a first col. in my pivot table?

[sergio0592]

And in Properties/Sort tab, if use sort with expression ?

[fj11]

Already tried sorting  ,with the sorting expression on on 'rowno() dimension'. but then the serial nos are displayed as random numbers like 10, 5, 3,1,7  etc instead on 1,2,3,4,5

I have attached screenshot for your reference for the numbers displayed as serial no. when i add sorting expression on rowNo() dimension

[Brett_Bleess]

Stupid question, would RecNo() work in this case instead of RowNo()?

Regards,
Brett

[firoz24]

I have same issue is it possible ?

Did you find the solution?

[marcus_sommer]

AFAIK the rowno() dependency to the sorting isn't to change. But you could try to replace it with a rank() approach, like:

aggr(rank(YourSortExpression), Dim1, Dim2)