Changing the category order in a variable
You can change the category order in a variable, either for all tables that use the variable or for a specific table.
Changing the category order for all tables
1 Select the Define tab.
2 In the Variable List, select the variable you want to change.
3 From the menu, choose Variables > Edit.
This opens the Edit Variable dialog box: see
Edit Variable dialog box.
4 To move a category up the list, highlight the category and click Move Up.
5 To move a category down the list, highlight the category and click Move Down.
You can use Ctrl+click and Shift+click to select multiple categories and then click Move Up or Move Down to move them all up or down the list.
6 Click OK.
Note The changes are applied to any existing tables that include the variable next time you populate them (provided you haven't used the Edit Axis dialog box (see
Edit Axis dialog box) to specify how the variable is to appear in any of those tables).
Changing the category order in the current table
1 In the Table List, select the required table.
2 Select the Define tab.
3 In the Table Definition section, select the variable that you want to change.
4 Click the
Edit Axis icon
on the Table Definition toolbar.
This opens the Edit Axis dialog box: see
Edit Axis dialog box.
5 To move a category up the list, highlight the category and click Move Up.
6 To move a category down the list, highlight the category and click Move Down.
You can use Ctrl+click and Shift+click to select multiple categories and then click Move Up or Move Down to move them all up or down the list.
7 Click OK.
See also