How to calculate Rank from score in the attached app

[bhavvibudagam]

Hi Experts,

Can any one please help me on this.

I have 4 excel source files attached below.

I have to calculate the score of clients related to that month only.

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.

[swuehl]

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

should work as expected (note that I've added all dimensions of your chart to the aggr dimensions.