Short Answer: Add row, column, or value fields first; then use the Sorting area to configure ordering once fields are present.
PreRequisites
- At least one row, column, or value field added to the report.
Steps
-
Add the row, column, or value fields you want to sort. See Rows, Columns, Values.
Fields appear in their respective sections. -
Scroll to or open the Sorting section.
Sorting options appear for the fields you added. The screen shows: 'Add row, column, or value fields to configure sorting.' -
Use the sorting controls that appear to set the order for rows, columns, or values.
Report reflects the configured sort order.
Troubleshooting
- Sorting controls do not appear.
LikelyCause: No row, column, or value fields have been added yet.
Action: Add fields to Rows, Columns, or Values; the Sorting controls will display once fields exist.
Note: The Sorting area displays the note: 'Add row, column, or value fields to configure sorting.' Details of sorting controls are shown only after fields are added.