Print Page - Problem to Display Top 10

Title: Problem to Display Top 10
Post by: prezan20pec on 10 Apr 2011 01:10:05 PM

Hi All,

I have a problem in displaying top 10 records.

I have a situation like this. I have table where there are emails sent out to some of the users in the country. I have also a measure called as Average.

So there are three columns: Country, Delivered and Average

I have aggregated the rows at Global Level and I want to see the top 10 rows based on the Average.

Also I want to apply one another condition - only records having delivered > 1500 should come and then ranking should be applied on Average.

When I apply any one of the condition it is working but when I apply both it is not working. Pls help.

Thanks.

Title: Re: Problem to Display Top 10
Post by: PRIT AMRIT on 10 Apr 2011 08:53:06 PM

Have attached the solution for you, see if it helps?

Thanks
Prit

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: prezan20pec on 10 Apr 2011 01:10:05 PM