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.
- In the table, click the header of the column containing the values you want to sort by.
- In the opened menu, beneath Sorting, click to sort from lower to higher values, or click to sort the from higher to lower values.
If you want to sort by the values in more than one column, click the header of the next column while pressing Shift + Ctrl.
Within each group of equal values from the first sorting, the rows are sorted by the column values in this second column in an ascending order.
The table below lists male and female customers of different ages, and located at two different places.
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.
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.
If you click the Age header while pressing Shift + Ctrl , the ages will also get sorted within each sorted group.