Working with Aggregate Tables

Use Aggregate Tables to report questions asked multiple times, for example for the first mentioned brand and the second mentioned brand.

You can create:

Before you create an Aggregate Table, you must first create the required aggregate variables.

When a question is asked for each mentioned brand, the dataset contains variables such as Brand1, Brand2, and so on.

For example:

Each of these variables contains all possible brands as categories.

Create an aggregate variable named Brands that contains all these variables. Use this variable as the banner variable.

The Stub Variable

For each mentioned brand, you may also have asked a follow-up question, for example whether the brand offers good service.

For example:

Create an aggregate variable named Service that contains all these variables.

After you create the Brands and Service aggregate variables, you can create an Aggregate Cross Table.

This table gives you an overall view of how the brands were rated.

You can think of this as the aggregated result of these tables:

Use an Aggregate Grid Table when you want to report several variables for each mentioned brand in the same table.

For example, you may have asked whether each brand:

In this case, you must create separate aggregate variables for each brand position.

For example:

Then create the table like this:

Create the aggregate variable Brands.
Create aggregate variables such as BrandProperties1, BrandProperties2, and so on.
Create a grid table with the BrandProperties variables in the stub.
Use Brands as the banner.

The resulting table shows the variables in the stub split by brand.

You can think of this as the aggregated result of these grid tables: