Sorting grid tables

Professional > Table scripting > Table presentation > Sorting tables > Sorting grid tables

Sorting grid tables

Sample script file: SortedTables.mrs

This example script is based on the Museum sample data set. See Running the sample table scripts for more information.

You can sort the columns and rows of a grid table. For example, using the Museum Rating grid table shown in Creating a grid table, we can sort the rows on one of the columns (which are formed from the categories of the variable inside the grid) and we can sort the columns on one of the rows (which are formed from the iterations). Here is the code:

With TableDoc.Tables
  .AddNewGrid("SortedRatingGrid", "rating", , "Rating grid - sorted")
  ' Sort on one of the rating categories
  .SortedRatingGrid.SortColumn = "rating[..].Column{Very_interested_5}"
  .AddNewGrid("SortedRatingGrid2", "rating", , "Rating grid - sorted #2")
  ' Sort on the iterations
  .SortedRatingGrid2.SortRow = "rating{Dinosaurs}"
End With

Here is the first table in which the rows are sorted on the Very interested column:

Here is the second table in which the columns are sorted on the Dinosaurs row:

Note that you do not normally sort a grid table on the base row or column. See The base in grid tables.