How To Manage Subtotals And Grand Totals In Excel For Mac


show more Managing subtotals and grand totals provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Managing subtotals and grand totals

Excel PivotTables display your data in as much or as little detail as you prefer. Pivoting the PivotTable changes how the individual data elements are displayed, but you can also position the subtotals and grand totals for rows and columns to summarize your data as desired. So let's take a look at this by now familiar PivotTable, where I have my rows, which are the months, and then also I have FirmA and FirmB. On the right side, I have my Grand Total column, where I have a total for all the values in a particular row, and then at the bottom I also have grand totals for the columns, which adds up all of these values here. And then you have a grand total for the entire worksheet.

Now let's see what happens when I add the Year field to the Row Labels area. To do that, I will drag the Field header from the Field name box down to the Row Labels box. It's in position, and there it is. When you have two or more fields in either the Row Labels area or the Column Labels area, Excel cre...

Managing subtotals and grand totals
Video duration: 3m 23s 6h 32m Beginner

Viewers:

Managing subtotals and grand totals provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

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