Layout: Grand Totals The Grand Totals can be added to the Rows, the Columns, both or neither. Before You Begin: Select the PivotTable. The PivotTable Tools should be available.   Edit the Field List, please. Row Labels: Products Column Labels: Category Values: Sum of Amount Try it: Change The Grand Totals Layout Go to PivotTable Tools ->Design. Go to Layout-> Grand Totals. Select: On for Rows and Columns.   What Do You See? The options for the Grand Totals include the following: Off for Rows and Columns On for Rows and Columns On for Rows Only On for Columns Only

PivotTable Tools ->Design-> Layout-> Grand Totals Exam 77-888: Microsoft Excel Expert 2010 3. Presenting Data Visually 3.3. Apply and manipulate PivotTables: Design Layout Grand Totals