ranking with dimension limit and show others value

[#1]

Hi,

I need to create a straight table with a product dimension, an amount value and the rank based on the amount: please see the first image.

In order to see only the top 10 products I apply a dimension limit showing only the largest 10 amount.

Since I want to see also the remaining products I flag the 'show other' option.

My issue is: I don't want "Other Product" to be considered in the rank column

Product1 should be rank 1, product2 rank 2, ...., Product9 rank 9.

Has someone a solutions for the problem?

Thanks in advance.

Please see also the attached .qvw with the example.

[sunny_talwar]

Try this:

=Rank(If(Len(Trim(PRODUCT)) > 0, Sum(AMOUNT)),1,1)

[#3]

Thank you!