Help with Rank Function

[rajua99]

Hello,

I have a Graph in my report and the default measure on that query is # of projects and the Y Axis is the Project manager.

My requirement is to show how many projects each project manager has in the form of Graph.

Now they want to display only top 10 project managers who got highest number of projects.

I am having difficulty on how to apply Rank Function on the Query to display top 10 Project managers in the Graph.

Can you help me on how to apply rank function on that Query..

Thanks in advance,
Raju

[Ganesh Kedari]

Hi
You can refer http://cognosgeek.wordpress.com/2012/11/08/show-top-10-values-in-cognos-report-studio-chart/
Let me know if you get any issues while applying this.

[Satheesh]

you can use a filter in Query like
rank(<your measure>) <= 10


I think Series is not required
X-axis is Managers list
Measure is - No.of Projects data item


this will show only top 10 PM's
Sort the X-axis by using rank data Item{ rank(<measure_no.of projects>) }


Regards
Sateesh