Sorting grid tables
You can sort the columns and rows of a grid table. For example, when you tabulate the Museum Rating grid table you can sort the rows on one of the columns (which are formed from the categories of the variable inside the grid) and you can sort the columns on one of the rows (which are formed from the iterations).
Grid table sorted on Very Interested column
For example, in the following table, the rows are sorted on the
Very Interested column. To do this, select
rating[..].Column{Very_interested_5} from the
Sort rows based on list on the Sort tab of the Table Properties dialog. For more information, see
Sorting tables.
Grid table sorted on Dinosaurs row
In the following table, the columns are sorted on the Dinosaurs row, by selecting rating{Dinosaurs} from the Sort columns based on list:
Note that you do not normally sort a grid table on the base row or column.
See also