Advanced Sorting Options

You can sort the values that are displayed in the Data Grid using the Advanced Sorting window. Sorting options that you apply to the Data Grid do not affect any workbook visualizations that are based on the dataset and should only be used to improve the readability of the values presented in the grid. To filter the values included in your dataset, you must create criteria filters using the Criteria Builder, located above the Data Grid. For more information, see Dataset Criteria Filters.

To open the Advanced Sorting window, click the Field Menu icon next to a column in the Data Grid and select Add Sort... from the menu.

In the advanced sorting window, you can set up sorting conditions for any field in the Data Grid. After you set up each condition, you can select the order in which each condition should be considered.

The elements of the Advanced Sorting window are identified in the following image:

1	Up/ Down Arrows — Click the arrows to change the order of the sorting conditions. Alternatively, click and drag the entire row to the location you want to move it to.
2	Field list — Select the field you want to create a sorting condition for.
3	Sort — Sort the result set in ascending or descending order, based on the values of the selected field.
4	Options — Click this icon to view the following options specific to the selected sorting condition: NULL First — If checked, blank values for the selected field are listed first in the corresponding column in the Data Grid. Case Sensitive — If checked, values beginning with capital letters are listed first in the corresponding column in the Data Grid. Language — Sort the result set based on the alphabetic sequence of the selected language.
5	Delete — Remove the selected sorting condition.
6	Add Sorting — Add another sorting condition, for a different field.
7	OK — Apply the selected sorting conditions to the Data Grid. Cancel — Close the Advanced Sorting window without making any changes to the existing sorting conditions. Remove All — Remove all of the sorting conditions currently listed in the Advanced Sorting window.

Related Topics