Now I want to Rank the first dimension with second dimension value.
For example : Here I am showing customer status by customer type.
So the formula goes like: RANK("F1 Revenue"."1-01 Revenue (Sum All)",20 by "D1 Customer"."C3 Cust Type")
You can also use TOPN in the place of RANK function.Thanks for the visit.