Overall rank is changing based on selection

[vamshi_1241]

Hi,

I have growth_rank, %growth_rank and PTQ _rank in my report. I had to show the overall rank (over these ranks) and I did and ranks are showing as expected but whenever we make a single selection on dimension,rank is showing 1 but I want their actual ranks after selection. Please let me know what I should do in this scenario.

Below is the logic I have written in expression:

aggr({1}Rank(

Aggr({1}Rank(growth_rank, 4,1),[Rep])

+

Aggr({1}Rank(%growth_rank,4,1),[Rep])

+

Aggr({1}Rank(PTQ_Rank ,4,1), [ Rep]),4,1),[Territory - Level 10 Rep])

[sunny_talwar]

Super