Survey Tabulation > Base elements > Hiding the base element
 
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
Base elements