Keep the same Rank after selection

[regowins]

Hi, I am using a calculated dimension to give me the Rank of payers. I want to know how to keep the payers rank even when I select only one payer. For example, in the chart I have 5 payers, of which payer X is currently ranked 4 and payer Z is ranked 2. If I select only Payer X his rank changes to 1. I would like his rank to show 4 even though I only have one payer selected.

I am using the following calculated dimension.

aggr(rank(total sum([Care Amt]),4,1),[Payer Name])

Thanks!

[swuehl · Accepted solution]

Try a set analysis set identifier 1:

aggr(rank(total sum({1} [Care Amt]),4,1),[Payer Name])

[regowins]

Yes, Thanks again!!!