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.
View solution in original post
Thanks Sunny. It works..