Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus
11g Release 1 (11.1.1)

Part Number B40105-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

Edit Worksheet dialog: Sort tab

Use this tab to change the sort order of items on the current table worksheet. For example, you might want to order numeric sales data from highest to lowest to look at sales performance.

Note: You won't find a Sort tab on the Edit Worksheet dialog for crosstab worksheets. To sort a crosstab worksheet, choose Tools | Sort to display the "Sort Crosstab dialog".

This dialog is also displayed as:
Worksheet Wizard dialog: Sort page

For more information, see:

"About sorting on table worksheets"

"How to sort data on a table worksheet"

"Examples of sorting"

<Sort list>

Use this list to manage how the worksheet data is ordered. Sorts are arranged in order of precedence.

Note: Group sorts automatically take precedence over non-group sorts.


This field displays the name of the item on which the data is ordered.


Use this drop down list to change how the data is ordered.

Sort Type

Use this option to group data and not display duplicate values. For example, if you sort on year, and there are many rows for 2001, the value 2001 is displayed only for the first row with that value. Note the following:

For more information about group sorting, see "What is group sorting?".


Use this option to hide or display the sorted item on the worksheet, as follows:


Use this button to add a new sort to the worksheet. The sort is added to the sort list. Click the button to display a list of items available, then click an item to create a sort on that item.


Use this button to remove the sort currently selected in the sort list from the worksheet.

Move up

Use this button to change the order of precedence of the selected sort item. Moving a sort up the list increases its precedence.

Move down

Use this button to change the order of precedence of the selected sort item. Moving a sort down the list decreases its precedence.