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!!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.