Sort Options

Sort options control the display order of dimension members using alphabetical, numeric, manual, or field-based sorting. They organize data for easier interpretation and highlight important values. Sorting can be ascending, descending, or based on aggregated measure values. Manual sorting allows complete custom ordering of dimension members.

To control the display order of the dimension member, perform the following steps.

1. With OrderDate from Kyvos, create a view with Sub-Category on Rows and Sum Sales on Columns.

2. Click the sort icon in the toolbar (ascending/descending bars).

   Open

   

3. For more control, click the Sub-Category pill, then select the Sort icon dropdown.

   Open

   

4. Select Sort to open the dialog.

5. Choose the sort order as Ascending or Descending.

   Open

   

6. Select sort by: Data source order, Alphabetic, Field (Sales), or Manual.

7. For Manual sorting, drag members to the desired order.

8. Click Ok.

9. Right-click the field in the Data pane > Default Properties > Sort to set the default.