Show dynamic RowNo in straight table

[#1]

Hi,

I'm trying to achieve a dynamic ranking based on active sort order in a straight table. In the example below I have sorted on Product Name, Sales and Margin. Actually the the only thing I need is a static row number as a Rank field. I have tried with RowNo() but without success.

Thanks in advance for helping me out.

Best regards

/ Matt

[#2]

Use this expression..

RowNo(TOTAL)    

Karthik

[#3]

For me that doesn't work. RowNo(TOTAL) only seem to sort on Product name regardless my chosen sort order. (double click on headername).

[#4 · Accepted solution]

Hi.

Find attachment.. It will solve ur problem.

But it very old method. May be some one else give good solution..

[#5]

Thanks a lot! Smart solution.

/ Matt

[eddysanchez]

karthiks, Not found for 2 dimensions

I think better use RowNo(TOTAL)

[#7]

But for his case.. he need to use sort option..

If we use RowNo() then sort option doesn't work ..

Karthik

[MaxC]

Thanks, this does work....make sure you select Full Accumulation on the Rank expression