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

There will be three levels of grouping, first by year, then by region, and then by (product) category.

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.

Select end topics, including the desired rollup calculations

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

This data set lists cereal categories (through row 14) and individual cereal products (from row 15 down). The rollup calculations will apply to the categories. Because these categories don't have values for columns C to H, BigPicture requires asterisks in these columns if rollups are desired.

Data set for the linked map

Specify relationships

You first indicate how topics are linked (i.e., related).

Specify relationships

Specify desired rollup calculations

In this example, it makes sense to request averages for the four numeric columns. For example, the map will show the average price per ounce for all cereal products in the data set and for all Kelloggs products in the data set.

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 relationships

You first indicate the employee-to-supervisor relationships.

Specify relationships

Specify desired rollup calculations

In this case, for each employee, the total salary of all direct and indirect subordinates will be shown. Also, by using the keyword Headcount, the number of all direct and indirect subordinates will also be shown. For an employee with no subordinates, only that employee's salary will be shown.

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.