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.

You can achieve this by entering the following into the top or side axis:

The following table shows the results:

For more information on how the IncludeInBase property affects base elements, see Excluding information from the base element.