When you use the hierarchical view of the data, you can define the level at which each table is generated. The level that you choose affects the figures that are shown in the cells of the table. The level you use to generate your results will depend on the level of detail you are interested in. For example, in the Household sample data set, when you generate a table at the top level, each case corresponds to a household and therefore the counts show numbers of households; when you generate the table at the person level, each case corresponds to a person and therefore the counts show numbers of people; when you generate a table at the trip level, each case is an overseas trip and the counts show numbers of trips, and so on.

This topic uses the Household sample data set to illustrate how data is generated at different levels. For details of the structure of the Household sample, see The Household sample.

All tables in this topic have a single cell item, Counts, and are set up to hide rows and columns where the base count is zero. (to change these properties, press F4 to display the Table Properties tab and set the properties in the Cell Contents and Hide tabs).