Hiding the base element
By default, a base element is always included in each variable in your tables. However, you can choose to hide the base element so that it is not shown on the table. You can do this in the Script tab of the of the New Variable, Edit Variable, or Edit Axis dialog boxes (see
Edit Variable dialog box: Script tab, or by typing the syntax directly into the Side or Top text box on the Define tab. For example, here is a table of
age by
gender in which the base elements have been hidden.
Table showing age by gender; bases hidden
You could create this table in the Museum data set (in which age and gender are both categorical variables) as follows:
1 Start a new table.
2 Click the Advanced View button.
3 Type the following in the Side Definition text box:
age{Base() [IsHidden=True], ..}
4 Type the following in the Top Definition text box:
gender{Base() [IsHidden=True], ..}
5 Click the
Populate icon
.
Note You can also use this syntax to hide categories and other items that appear in your tables. See
Hiding categories for more information.
Hiding the base element in exported tables
If you are exporting tables to Microsoft Excel spreadsheets, you can choose to hide all bases in your tables so that they do not appear in the output files. You do this by selecting the
Hide base elements check box in the
Microsoft Excel Exports dialog box. This overrides the settings in the tables.
See also
