Chapter-8: Subtotals And Grand Totals

Subtotals and Grand totals can be added or removed from a pivot table easily.

Subtotals:

In a PivotTable, subtotals are calculated automatically and show by default. But if you don’t see them, you can add them.

Below are the subtotal option available in a pivot table

Note : In Tabular layout subtotals can not be displayed in top of group.

After adding the subtotals at Bottom pivot table will look like below image –

After adding the subtotals at Top pivot table will look like below image –

Grand totals of Rows or Columns by default is always on. You can off the Grand from Rows and columns.

Below are the Grand Total option available in a pivot table

Click anywhere in the pivot table.
Go to Design tab>>Layout group>>Grand Totals
To off all Grand Total in the pivot table click on Off for rows and Column.
To on all Grand Total in the pivot table click on On for rows and Column.
To On the Grand Total for rows in the pivot table click on On for Rows Only.
To On the Grand Total for Columns in the pivot table click on On for Column Only.

Pivot table after Grand total off will look like below image-

Page updated

Google Sites

Report abuse