How to Sort Labels in an Ascending or Descending Order

Introduction

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 to the Page to create a table.

Method

1. Select a cell in the row header.
2. 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.

See Also

How to Automatically Sort Table Rows

How to Sort a Table by Values

How to Sort a Table Based on Patterns