Sort ad hoc analysis table output
To find relevant information more easily, you can sort the table output of an ad hoc analysis by specific columns.
Activate the
Output bar and select the columns to be sorted.Activate the Data tab bar and click
Sort ascending or
Sort descending. If you have selected a single column, a warning is displayed. Make sure to select the Expand selection to entire table option and click OK. Otherwise, references to other cells are lost.
You have restored the table.