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.
Can u describe more on this?
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.
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.