rank()

[bhavvibudagam]

Hi Experts,

Can any one please help me on this .

In the below table for the the month year Apr 2018 for client002 The rank is 305

but when i filtered client0002 particularly then 305 changed to 1.

Please help me on this.

I have used this expression

aggr(rank(sum(score),0,1),clientid)

Thanks in advance

[swuehl]

Try maybe

aggr(rank(sum({1} score),0,1),clientid)

or

aggr(rank(sum({<clientid>}score),0,1),clientid)

[swuehl]

The first one ignores all selections, the second one only selections in your client field.

Both should work in priniciple. Have you tested the second?

And why are you using the Aggr() function here?

[bhavvibudagam]

HI Stefen,

I have prepared a sample app with sample files about the above rank() requirement.

I have 4 excel source files attached below.

I have to calculate the score of clients related to that month only in a Table box.

Suppose in the Jan month client0145 has the rank 1 with in feb month his rank is 2 based on that month related client score.Please help me on this.

Tried with aggregation function but not working. Please help me on this.

[swuehl · Accepted solution]

=aggr(Rank(sum({1}Score)),Month, Client)