Sorting tables
You can sort tables on rows, columns or specific items, in ascending or descending order. ee
Sorting tables.
To sort a table
1 In the Tables pane, select the table that you want to sort.
2 Click
Tables >
Properties, and then click the
Sort tab.
3 In the Sort rows based on or Sort columns based on list, click the column or row that you want to sort on. Alternatively, choose one of the First/last row/column options. These options are useful if you add new categories to your surveys over time and you want to reuse the tables. For example, if you have a table containing monthly data, you can select Last column to sort the table by the latest month, rather than selecting the name of the month each time you update the data.
If required, you can sort on both rows and columns.
To sort columns, you select the row on which to sort, and vice versa.
4 Click ascending order or descending order.
5 Click
OK, and then generate the table to see the results of your changes: click the Generate table button
.
You cannot apply sort options to multiple tables, as the options available depend on the rows and columns in individual tables.
See also