'Detach' the rank function..maybe with set analysis?

[#1]

I have a problem with the rank function. The behaviour I need in the sample file attached is as follows:

- Person 'N' is ranked 9th when no selections are made

- If I select Person 'N' then his rank changes to 1st (as the data set is now just one person)

- However, I need chart object CH64, to show his rank assuming no selections had been made

Is that possible?

Thanks in advance!

[#2]

Hi,

Please find the attched sample file.

Regards,

Ravi

[#3]

Thanks Ravi.

Is it possible to have object CH64 show ths rank though OR is it possible to have all the other rows in the main chart hidden except the one selected?

For example, if I select person E then CH64 shows '1' where as I want it to show '15'. Possible?

[johnw · Accepted solution]

This works in both objects:

aggr(rank(sum({1}Points)),Person)

Though you may want this, as it should respect all of the other possible selections. For instance, if you had a date field on which you earned points, and you selected this year, you probably want the rank of the person this year, not for all years.

aggr(rank(sum({<Person=>}Points)),Person)

[#5]

John, that's absolutely fantastic. Thanks a lot for your help!