Next
You can sort tables on rows, columns or specific items, in ascending or descending order. See the topic Sorting Tables for more information.
► In the Tables pane, select the table that you want to sort.
► From the menu, choose:
► Choose the Sort tab.
► In the Sort rows based on or Sort columns based on drop-down list, choose 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.
Note: To sort columns, you select the row on which to sort, and vice versa.
► Choose ascending order or descending order as required.
► Choose OK to close the Table Properties dialog box, save your changes, and apply them to the current table.
► Generate the table to see the results of your changes:
Note: You cannot apply sort options to multiple tables, as the options available depend on the rows and columns in individual tables.