Tuesday 10 January 2012

RANK and TOPN Functions

I am pulling columns required to display rank function.  First column is a dimension and second is a measure column and third column is a column with Rank function as shown below:
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")

 And see the result. The result is not in proper order. So we give ascending order for the third column.
 Now see the result and it appears fine.
You can also use TOPN in the place of RANK function.
Thanks for the visit.

No comments:

Post a Comment

Thanks to Comment
--Add--