Static Ranking in WebI 4.1
I have a requirement where I need to rank the data based on Total Cost. Basically, the report has 2 tabs. In the first tab,I need to rank by applying some filters which is done. Now the same table is copied in the second tab and if I filter it out ,the positions which were there previously are changing and its beginning from 1...n so on..But I dont want in that way. I need only those positioned rows to be picked to know which groups got approved or awaiting for technical repairs. Just the way as Excel does when filtered out where the positions of records/row numbers are static. Appreciate your help.