# What are rollup calculations?

Rollup calculations produce summary measures in special BigPicture maps, including data maps, linked maps, and org charts. Examples are provided below.

## Rollups in data maps

### Data set for the map

Here is a typical data set for a data map, where each row includes sales information for some product in some country in some year.

### Select grouped topics

### Select end topics, including the desired rollup calculations

Two numeric columns will be summed and included in rollups. For example, the map will show total profit for the entire data set, total profit for 2011, total profit for North America in 2011, and total profit from sales of hair care products in North America in 2011. (By checking the bottom Rollup End Topic Count option, the grouped topics also show the record counts, i.e., the number of data rows, in each topic.) If the rollup boxes weren't checked, these totals (and counts) wouldn't appear in the map, but totals for the two numeric columns would appear in the end tables. For example, the end table would show total profit for each product separately, and/or for each country separately.

### View rollup results

Here are some of the rollup calculations. If the rollup boxes weren't checked, totals for Units Sold and Profit wouldn't appear in any of these topics.

## Rollups in linked maps

### Data set for the linked map

### Specify desired rollup calculations

### View rollup results

Here is a sample of the category topics. If rollup calculations weren't requested, none of the topics would contain any of these averages.

## Rollups for an org chart

### Data set for the org chart

This data set not only includes the two columns (second and third) that define the employee-to-supervisor relationships, but it also includes a numeric variable, salary, that can be used for rollup calculations.

### Specify desired rollup calculations

### View rollup results

The rollup results are shown in "topic notes" indicated by summation signs. A few have been opened here. For example, Loretta Smith supervises 11 employees, directly or indirectly, and their total salary is $1,142,500. On the other hand, Harold Cross supervises no one, and his salary is $64,600.