If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Problem to Display Top 10

Started by prezan20pec, 10 Apr 2011 01:10:05 PM

Previous topic - Next topic

prezan20pec

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.

PRIT AMRIT

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

Thanks
Prit