Desktop User Guides > Professional > Table scripting > Table specification syntax > Element properties > Excluding categories from the base
Excluding categories from the base
Sample script file: IncludeInBase.mrs
This example script is based on the Museum sample data set. See Running the sample table scripts for information on running the example scripts.
You can exclude particular categories from the calculation of the base, while still including the categories in rows or columns in the table. For example, you might want to include rows for 'No Answer' or 'Refused' responses in a table, while excluding these responses from the base, or from any calculations that use the base, such as percentages.
One way to do this is by setting the IncludeInBase property of the categorical element to False. This prevents the value for the category from being counted in the base, and automatically ensures that any summary statistics calculated from the base also exclude the category.
"museums{..Northern_Gallery, Other 'Other (excluded)' [IncludeInBase=False]}* gender"
You can achieve this by entering the following into the top or side axis:
museums{..Northern_Gallery, Other 'Other (excluded)' [IncludeInBase=False]
The following table shows the results:
This graphic is described in the surrounding text.
For more information on how the IncludeInBase property affects base elements, see Excluding information from the base element.
See also
Element properties