Sorting Relational Data
You can sort items to view them in your preferred order. By default, IBM® Cognos® Analytics - Reporting retrieves items in the order defined in the data source. OLAP data sources always have a defined order. Relational and dimensionally-modeled relational data sources may not always have a defined order. The data modeler defines the sorting options in the model.
For more information about data modeling, see the IBM Cognos Framework Manager User Guide. Sorting applied in Reporting applies only to the layout within the report.
You can sort items in a list in ascending or descending order based on a value or a label, such as revenue or employee name. You can also perform advanced sorting to sort columns within groups or to sort a row or column using another data item.