␡
- Launch Query Studio
- Query Studio High-Level Interface
- Report Types
- Open an Existing Report
- Create a List Report
- Run the Report
- Change Layout
- Create a Crosstab Report
- Create Filters
- Summarize Report
- Sort Data
- Create Calculations
- Create Charts
- Define Conditional Styles
- In a Nutshell: Reviewing by IBM Cognos BI Audience
This chapter is from the book
This chapter is from the book
This chapter is from the book
This chapter is from the book
Sort Data
Use the Sort option to display data in ascending or descending order. You can also remove any Sort option currently applied to the report.
To sort data, perform the following steps:
- In IBM Cognos Connection, click Launch > Query Studio.
- Select the GO Data Warehouse (query) package when prompted to select a package.
- Click New icon on the Standard toolbar to create a new report.
- On the Insert Data menu, navigate to Sales > Products > Product line > click the Insert button.
- On the Insert Data menu, navigate to Sales > Order Method > Order Method Type > click the Insert button.
- On the Insert Data menu, navigate to Sales > Sales fact > Quantity.
- Click Order Method > click the Pivot icon on the Standard toolbar.
- Click Order Method > click the Edit Data menu. Click Sort > select Descending.
In addition, you can sort or filter items that do not appear in the report by right-clicking on the item in the metadata tree, as shown in Figure 5.18.
)
Figure 5.18. Sort or filter data items not included in the report.