The Column/Sort Order tab allows the rearrangement of columns and changes to the sort order used to create a table.
Select an item from the menu. The menu options depend on the table type and the variables mapped to each context.
Row ID, Row Stratification, or Column Stratification requires at least one variable to be mapped to the corresponding context.
Data and Dependency requires that two or more variables be mapped to the corresponding context.
Statistics requires that two or more statistics be selected for display in the Statistics tab.
To change the sort order of Row ID, Row Stratification, or Column Stratification variables from ascending to descending and back again, double-click the variable.
To change the display order of variables or statistics listed, select an item in the list and click the up or down arrow buttons to move the item within the list.
To sort rows based on a list of row IDs:
Select the column in the Row ID list.
Press Add Custom Sort to display a second list of all values in that column.
“(Custom)” is appended to the column’s name in the first list.
Select an ID in the second list and use the arrow buttons to change the display order.
To remove a custom sort order, select the column in the first list and press Remove Custom Sort.