You can use layers to add a dimension of depth to your tables, creating three-dimensional "cubes." Layers are similar to nesting or stacking; the primary difference is that only one layer category is visible at a time. For example, using Age category as the row variable and Gender as a layer variable produces a table in which information for males and females is displayed in different layers of the table.
To Create Layers
- Click Layers on the Table tab in the table builder to display the Layers list.
- Drag and drop the scale or categorical variable(s) that will define the layers into the Layers list.
You cannot mix scale and categorical variables in the Layers list. All variables must be of the same type. Multiple response sets are treated as categorical for the Layers list. Scale variables in the layers are always stacked.
If you have multiple categorical layer variables, layers can be stacked or nested.
- Show each category as a layer is equivalent to stacking. A separate layer will be displayed for each category of each layer variable. The total number of layers is simply the sum of the number of categories for each layer variable. For example, if you have three layer variables, each with three categories, the table will have nine layers.
- Show each combination of categories as a layer is equivalent to nesting or crosstabulating layers. The total number of layers is the product of the number of categories for each layer variable. For example, if you have three variables, each with three categories, the table will have 27 layers.
See Pivot Tables options for information on how multiple layer dimensions are rendered in lightweight tables.