Microsoft® Office Excel® 2007 Inside Out

Displaying Totals and Subtotals

By default, Excel generates grand totals for all outer fields in your PivotTable using the same summary function as the body of the table. In Figure 22-3, for example, row 30 displays grand totals for each quarter of each year, as well as for the years themselves. Column L, meanwhile, displays per-category totals by channel. The intersection of column L and row 30 displays the grandest of totals, the sum of all sales for the period covered by the table. Because the body of the table uses the SUM function, all these grand totals do as well.

To remove grand totals from a PivotTable, right-click any cell in the table, and click PivotTable Options. On the Totals & Filters tab in the PivotTable Options dialog box, clear ...