You can clear sorts that you have applied to columns in a view or analysis.
For example, you can clear all sorts in the Time column of the Brand Revenue analysis.
To clear sorts that you have applied in a pivot table, table, heat matrix, or trellis view, right-click in the view heading and click Clear All Sorts in View.
- Display the Selected Columns pane of the Criteria tab.
- Click Options beside the column.
- Select Sort, then Clear Sort.
When you clear sorts from the Criteria tab, you clear only the sorts that were defined from the Column Options menu. You don’t clear the sorting done within a specific view.
To remove the primary sort from the column to which it now applies and apply it to the column whose button you just clicked, click a sort button in an unsorted column.