Sorting a table
In a table visualization you can sort the rows by the values in a data column. Depending on the type of data, an alphabetical, numerical, or chronological sorting of the column values is applied. You can also make a subsequent sorting of the rows by the data in another column.
About this task
Procedure
Example
The table below lists male and female customers of different ages, and
located at two different places.
![Table](../../images/sorting_table_example1.png)
To get a more structured view of the table, the City header below has been clicked, followed by
in the opened menu, to
gather London and Manchester customers, respectively.
![Sorted table](../../images/sorting_table_example2.png)
Also, within each city, you may want to list male and female customers separately. Simply click the Gender header while pressing Shift + Ctrl. To list Male first, that is, to get a descending order, press the Gender header one more time while pressing Shift + Ctrl.
![Sorted table](../../images/sorting_table_example4.png)
If you click the Age header while pressing Shift + Ctrl , the ages will also get sorted within each sorted group.
![Sorted table](../../images/sorting_table_example5.png)
![Table](../../images/sorting_table_example1.png)
To get a more structured view of the table, the City header below has been clicked, followed by
![](../../images/cross_table_sort_ascending.png)
![Sorted table](../../images/sorting_table_example2.png)
Also, within each city, you may want to list male and female customers separately. Simply click the Gender header while pressing Shift + Ctrl. To list Male first, that is, to get a descending order, press the Gender header one more time while pressing Shift + Ctrl.
![Sorted table](../../images/sorting_table_example4.png)
If you click the Age header while pressing Shift + Ctrl , the ages will also get sorted within each sorted group.
![Sorted table](../../images/sorting_table_example5.png)
Parent topic: Table