Translate

Rank Function in Cognos Report Studio

If we have a List report with Columns Country, Product Name and Revenue, how do you show Top 2nd revenue generated Products for each Country?

1. Create a List report with columns Country, Product Name and Revenue


2. Open Query Explorer --> Create a Detail Filter as shown below:



3. Run the report to see top '2' Revenue generated Products for each Country.

Posted by

1 comment:

Anonymous said...

You are amazing. God bless you for your knowledge.

January 20, 2017 at 3:41 AM

Post a Comment

Subscribe to: Post Comments (Atom)