Home > Articles

  • Print
  • + Share This
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:

  1. In IBM Cognos Connection, click Launch > Query Studio.
  2. Select the GO Data Warehouse (query) package when prompted to select a package.
  3. Click New icon on the Standard toolbar to create a new report.
  4. On the Insert Data menu, navigate to Sales > Products > Product line > click the Insert button.
  5. On the Insert Data menu, navigate to Sales > Order Method > Order Method Type > click the Insert button.
  6. On the Insert Data menu, navigate to Sales > Sales fact > Quantity.
  7. Click Order Method > click the Pivot icon on the Standard toolbar.
  8. 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

Figure 5.18. Sort or filter data items not included in the report.

  • + Share This
  • 🔖 Save To Your Account