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?
Stupid question, would RecNo() work in this case instead of RowNo()?
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.