Brio Software
Technical Publications
Home Previous Next Index Glossary
Data Analysis and Reporting with Intelligence Clients

Adding Totals and Subtotals

You can calculate totals for both columns and rows in a pivot table. If you layered dimension items along the top or side of your pivot table, you can calculate totals for any Level in the Hierarchy. When you select inner dimensions for totaling, subtotals are created for each of the categories in the outer dimensions.

For example, assume your pivot table has facts of Units and Amount Sold. These facts are further broken down by Region and Territory on the side, and by Year and Quarter on top. Calculating totals by Region produces a total row at the bottom of the pivot table, summing the data from all regions for each column. Calculating totals by Quarter produces one total column under each year label, summing the data for each set of four Quarter labels.

*

Tip   An intelligent aggregate is applied to the specified data when totaling unless you specify otherwise. For example, the total of a column of averages will calculate an average rather than a sum total.

To add totals to a pivot table:

  1. Click a side or top dimension.
  2. Choose Pivot then Add Totals or click the summation icon on the standard toolbar.
  3. totals and breaks them according to the next higher dimension item.

To add subtotals to pivot tables:

  1. Select an inner dimension.
  2. Choose Pivot then Add Totals or click the summation icon on the standard toolbar.
  3. subtotals to each one of the categories of the next higher dimension.


Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.