Data sorting is the process that involves arranging the data into some meaningful order to make it easier to understand, analyze, or visualize. Data is typically sorted based on actual values, counts, or percentages, in either ascending or descending order. This article describes how to sort based on the labels. To illustrate this the table below shows the original data which is not sorted in any particular order:
The tables below have been sorted by the Label, on the left in Ascending order and, on the right, in Descending order.
Requirements
- A variable that has been dragged onto the Page to create a table.
Method
- Select a cell in the row header.
- Either:
- From the toolbar, click Sort > Categories Shown in Rows > By Label > Ascending if you want the rows to appear in alphabetical order or Sort > Categories Shown in Rows > By Label > Descending if you want the rows to appear alphabetical but in the reverse order. Both options are available for columns as well.
- Right-click and select Sort > Categories Shown in Rows > By Label > Ascending if you want the rows to appear in alphabetical order or Sort > Categories Shown in Rows > By Label > Descending if you want the rows to appear alphabetical but in the reverse order. Both options are available for columns as well.
Next
How to Automatically Sort Table Rows
How to Automatically Sort Tables to Show Patterns in the Data