Rank function not working!

[#1]

Hi Folks

I have a problem with a rank function in a pivot table, I'm using the following expression:

Rank ( TOTAL Sum ( {$1} REVs * Trade_YTDFlag ) ,1 ,1 )

When no filters are applied I would appear to be getting correct results as per following screenshot (note that I have obfuscated the client names for security, but the Red line is the one that I will filter on for the second image):

The problem is that when I filter on a particular client I get this:

I had thought that the {$1} in the sum function would work alongside the dimensions, but ignore selections but as you can see from the above screenshot all I now get is Rank 1 in every column when I should be seeing the exact same ranks as in the first screen.

Would appreciate any help you can provide.

[perumal_41]

Hi

use HRank function,

[#3]

Hi

HRank is a function that ranks a cell within the columns, i.e. would rank this cell against the other cells in the same row. This is not what I want, I am ranking the cell in a single column, but more importantly, ranking that cell whilst ignoring any selections that have been made.

Thanks,