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.