Ranking (Ignoring 2nd dimension)

[#1]

Hello All,

In the attached file , I am ranking as per customer.

As for customer 8 which is at rank 1, i want all brands also to get same rank which is one.

Then all brands with customer 7 should have rank 2....

What is the expression to achieve above requirement.

[sunny_talwar · Accepted solution]

Try this:

=Aggr(NODISTINCT rank(sum([Sales]),[Customer]),[Customer])

[#3]

Thanks Sunny. It works..