If there is data that you want to use to sort but that is not included as a result member, you can use the sorting options section of the Business Intelligence|Results page to sort.
The following procedure assumes you already have opened an existing BI query or are creating a new one. For more information, refer to the Business Intelligence|Search Page, Performing Searches and Creating a BI Query.
To sort by data not included as a result member, complete the following:
-
Select the Results tab.
The Business Intelligence|Results page appears.
-
Click 'Add Sort'.
A new row is added to the sorting options section.
-
Click in the 'Name' column and search for and select the field that you want to use in the sort.
-
Define how you want to sort by selecting Ascending (A to Z or 0 to 9) or Descending (Z to A or 9 to 0) from the 'Type' dropdown.
-
For each field that you want to use to sort, repeat the process from Step 2.
-
To preview your changes, select the Preview tab.
The Business Intelligence|Preview page appears.
-
To extract to Microsoft Excel or PDF, refer to Running a Saved Query
-
If you want to save your changes, expand the save lists and extracts section of the Business Intelligence|Results page and save your changes. For more information, refer to Saving a BI Query.