Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have a situation where I need to incorporate serial no in straight table also if I click on any measure column to sort the serial no will be generated according to that.
Thanks.
Farhan
Can u describe more on this?
Hi Farhan,
can you elaborate this, do you need rowno as a exp or dimension?
Regards'
sathesh
Try like this in the expression , you should get the result
Aggr(RowNo(),Dimension)
I just need serial no in starting whether in dimension or expression, I have a straight table in which I have different designations and their sales MTD and YTD eg. If I click on YTD it will sort the column and the serial should not be disturbed by this.
Thanks
I used this but when I click on any measures(eg YTD sales) it changed the order of serial no., serial no should not be disturbed by sorting of measures.
Thanks
If that the case define the rowno() in hte script level that will not change
try ROWNO() in expression if you have only one dimension if more than one dimesnsion try rowno(total)
Dear avinash,
I wrote in the script but the resultant column is not starting with 1.
Thanks, serial no are now not changing but the expressions became un-sortable