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