Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can i create rank in report studio 1

Status
Not open for further replies.

12ABC34

MIS
Apr 14, 2007
1
TH
i want to create rank of product in each year by qty sold. i want to filter data by year and i also want to limit number of rank by filter too. how can i do?
 
You can use the cognos rank function as a query calculation in report studio.
You can specify extended context in the rank expression and then apply a filter on the query calculation.

You should check whether you need to apply a before or after aggregation filter.

Actually, this is a very strong point in the Cognos suite!!

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top