Comma Training Page 106

The Grand Totals can be added to the Rows, the Columns, both or neither.

Before You Begin: Change The PivotTable
Select the PivotTable. The PivotTable Tools should be available.

Edit the Field List, please.

Rows: Products

Columns: Category

Values: Sum of Amount

4. 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

Keep going...