Sorting grouped values
The output of the previous recipe brings the right information back to the screen. It filters the rows correctly and shows highest selling product per product line for selected shipment month.
For better representation and to highlight the best selling product lines, we need to sort the product lines in descending order of quantity.
Getting ready
Open the report created in the previous recipe in Cognos Report Studio for further amendments.
How to do it...
- Open the report in Cognos Report Studio.
- Select the Quantity column.
- Click on the Sort button from toolbar and choose Sort Descending.
- Run the report to check if sorting is working. You will notice that sorting is not working.
- Now go back to Report Studio, select Quantity, and ...
Get IBM Cognos 8 Report Studio Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
