Reverse the Rank in 10.2

[Londa]

I am using Cognos 10.2. I have a list and need to rank having the "worst" number show up as Rank 1 (reverse the rank order). What is the best way to do this?

Thank you,

[Lynn]

I am using Cognos 10.2. I have a list and need to rank having the "worst" number show up as Rank 1 (reverse the rank order). What is the best way to do this?

Thank you,

Is this a relational or a dimensional package?

If it is relational, you can use the rank function and specify ASC rather than DESC. It assumes DESC by default so you need to change it if you want to rank the other way.

Code Select Expand


rank ( [Your Number] ASC )


If it is dimensional, then you'd want to use the bottomCount Function. If you have a set on rows in a crosstab, for example, you can edit that set and use the little wizard to define what you need.

As a side note, you've posted in the Cognos Analytics section when you should have posted in the Cognos 10 section. A moderator may move the post for you.

[Londa]

Thank you! Thank you! Thank you!

Works like a charm!