Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
And in Properties/Sort tab, if use sort with expression ?
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
Stupid question, would RecNo() work in this case instead of RowNo()?
Regards,
Brett
I have same issue is it possible ?
Did you find the solution?
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)