In this article
The properties on the Sorting tab enable you to sort the information in the table by both the rows and columns, and you can choose to sort either by a header variable on the opposite dimension, or by a particular column/row, identified by code or by the row/column’s position in the table counting from the start or the end. The figure here shows the Rows properties on the Sorting tab. The Columns properties are identical.
Figure 1 - The Sorting tab – Rows properties
In the examplehere below, the rows are sorted in descending order, based on the total score. The last three elements ("Other", "No Particular Favorite" and Total) are not included in the sorting.
Figure 2 - Sorting Example
In the Sorting tab, the properties are as follows:
- Check the Enabled box for the Rows and/or Columns pages as required to enable the sorting functionality.
- Direction – the direction of the sorting. Descending puts the largest value at the top of the list, Ascending puts the lowest value at the top of the list.
- Sort By Type – specify the content you wish to sort by. The options are;
- Header allows you to specify a "Header" variable from the headers on the other table dimension. Select the variable in the "Header" drop down, and then the sorting will be done based on the results on the cross with that header variable.
- You can also sort by a specific Code in the answer list of the item(s) on the other table dimension. The codes are shown in tool tips as you move the mouse pointer over the headers in the table preview.
- Position allows you to define which column or row the table is to be sorted by, counting "From Start" or "From End" of the table.
- Top / Bottom n – type in a number to display only the specified number of items with the highest or lowest scores. If both of these are set to 0, all items will be displayed.
- Fixed from start / end – defines a number of elements, from the start or the end, that are not to be included in the sorting, but remain in their positions at the start/end of the row/column. In the example in the "Sorting tab - Rows properties" figure above, the Fixed From End property was set to 3 for Rows to fix the "Other", "I have no favorite" and "Total" rows at the bottom of the list.