Display top Revenue in Report Studio

[cognos.cognosbi@gmail.com]

Hi All,

I know that to find top 5 or any Revenue in cognos report studio we have a function called TopCount() (or) write a Query in Report Studio.Please anyone suggest other solution except these 2 to find top values.

Thanks And Regards
cool cognos.

[MFGF]

TopCount() is a dimensional function for use with OLAP and DMR packages.  For a relational package, you might try adding a rank calculation, sorting on this, then filtering it to return values less than or equal to 5.

Regards,

MF.