Adding Totals and Subtotals

You can calculate totals for both columns and rows in a pivot table. If you layered dimension items along the column or side of your pivot table, you can calculate totals for any layer 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 column. 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 calculates an average rather than a sum total.

  To add totals to a pivot table:

  1. Click a row or column dimension.

  2. Select Pivot, then Add Totals or click Grand Total icon on the standard toolbar.

    The totals and breaks them according to the next higher dimension item.

  To add subtotals to pivot tables:

  1. Select an inner dimension.

  2. Select Pivot, then Add Totals or click the Grand Total icon on the standard toolbar.

    Interactive Reporting adds subtotals to each one of the categories of the next higher dimension.