Add and Remove Subtotals and Grand Totals in Excel 2008


show more Adding and removing subtotals and grand totals provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis show less
please wait ...

Adding and removing subtotals and grand totals

Excel Pivot Tables display your data in as much or as little detail as you prefer. Pivoting and filtering the Pivot Table changes how the individual data elements are displayed, but you can also show or hide the subtotals and grand total rows and columns to summarize your data as desired. Subtotals appear at the bottom of each group. In this case, we have the year 2008. Month is the lowest level of organization in the Pivot Table, so we don't have any subtotals for it. At the bottom of 2008, we have a subtotal for all the months for FirmA and all of the months for FirmB.

To control subtotals for a field, you click any cell on the field, in this case 2008 for year, and then on the PivotTable toolbar click the Field Settings button. From here, you can calculate how Excel calculates your subtotals. For example, if you wanted to hide them entirely, you could click None. Click OK and they go away. To make another change, click the Field Settings button. And if you want to change to another ca...

Adding and removing subtotals and grand totals
Video duration: 2m 44s 1h 7m Intermediate

Viewers:

Adding and removing subtotals and grand totals provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...