Server User Guides > Survey Tabulation > Working with variables > Removing categories from a table > Excluding a category from the base
 
Excluding a category from the base
This method removes the values for the category from the base and from any calculations that use the base, while still displaying the category values in the table. As the category still exists in the table specification, the values for excluded categories are included in any totals and subtotals that you add to the table.
65+ years category excluded from base
This graphic is described in the surrounding text.
In this example, the 65+ years category has been excluded from the base. You do this by applying the IncludeInBase property to the category and setting it to False, as follows (you must include the square brackets):
age{base(), E1116_years '11-16 years', E1720_years '17-20 years',
E2124_years '21-24 years', E2534_years '25-34 years', E3544_years '35-44 years',
E4554_years '45-54 years', E5564_years '55-64 years',
E65_years '65+ years' [IncludeInBase=False], 'Total' total()}
You can combine the IsHidden and the IncludeInBase properties to remove a category both from the base and from the table display. However, as it is still part of the table specification it still appears in any totals and subtotals that you add to the table.
65+ years category hidden and excluded from base
This graphic is described in the surrounding text.
In this example, the 65+ years category has been hidden from the table and excluded from the base, by applying the IsHidden and IncludeInBase properties as follows (to add both properties, include them in a single pair of square brackets, separated by a comma):
age{base(), E1116_years '11-16 years', E1720_years '17-20 years',
E2124_years '21-24 years', E2534_years '25-34 years', E3544_years '35-44 years',
E4554_years '45-54 years', E5564_years '55-64 years',
E65_years '65+ years' [IsHidden=True, IncludeInBase=False], 'Total' total()}
See also
Removing categories from a table