This article describes how to take a table with a default sort order:
And sort it by a specific column or row:
Requirements
- A Displayr document containing a table that you want to sort.
Method
- Select the table that you want to sort.
- Right-click on the column or row header that you want to sort by.
- Select Sort and then select one of the following options:
- Ascending (e.g. 1,2,3)
- Descending (e.g. 3,2,1)
- Categories Shown in Columns > By Labels > Ascending (e.g. A,B,C)
- Categories Shown in Columns > By Labels > Descending (e.g. C,B,A)
- Categories Shown in Columns > By Pattern - Sorting by patterns is used to highlight significant patterns in the data. This is sometimes called "diagonalization".
- Categories Shown in Rows > By This Column's Values > Ascending > Select Statistic (e.g. 1,2,3)
- Categories Shown in Rows > By This Column's Values > Descending > Select Statistic (e.g. 3,2,1)
Note: If sorting by values, normally, you'll want to select the top statistic (e.g. %), because it is what will be displayed on the table by default. However, you can also sort by another statistic that is not currently shown on the table.
Next
How to Sort Labels in an Ascending or Descending Order
How to Automatically Sort Table Rows
How to Sort Columns for Entered or Pasted Tables
How to Sort Rows for Entered or Pasted Tables
How to Automatically Sort Tables to Show Patterns in the Data
How to Sort Table Categories Within Each NET