How To Add Grand Total To Pivot Chart

Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More...Less

When working with a PivotTable, you tin brandish or hide subtotals for individual column and row fields, brandish or hide column and row one thousand totals for the unabridged study, and calculate the subtotals and grand totals with or without filtered items.

Subtotal row and column fields

In a PivotTable, select an item of a row or column field. Make sure information technology is a field and not a value.
On the Analyze tab, in the Active Field group, click Field Settings.

This displays the Field Settings dialog box.

In the Field Settings dialog box, under Subtotals, do 1 of the post-obit:

To subtotal an outer row or column label using the default summary role, click Automatic.
To remove subtotals, click None.

Annotation:If a field contains a calculated particular, yous can't modify the subtotal summary office.

To use a different function, to brandish more than one type of subtotal, or to subtotal an inner row or column label, click Custom (if this option is bachelor), and so select a function.

Functions that yous can utilise as a subtotal

Function	Description
Sum	The sum of the values. This is the default function for numeric data.
Count	The number of data values. The Count summary role works the same every bit the COUNTA part. Count is the default function for information other than numbers.
Average	The boilerplate of the values.
Max	The largest value.
Min	The smallest value.
Product	The product of the values.
Count Numbers	The number of data values that are numbers. The Count Numbers summary function works the aforementioned as the worksheet COUNT function.
StDev	An estimate of the standard divergence of a population, where the sample is a subset of the entire population.
StDevp	The standard difference of a population, where the population is all of the data to be summarized.
Var	An estimate of the variance of a population, where the sample is a subset of the entire population.
Varp	The variance of a population, where the population is all of the data to exist summarized.

Note:You lot cannot use a custom function that uses an Online Belittling Processing (OLAP) information source.

To include or exclude new items when applying a filter in which you take selected specific items in the Filter bill of fare, select or clear the Include new items in manual filter cheque box.

Tips:

To chop-chop display or hide the electric current subtotal, right-click the item of the field, and so select or clear the cheque box next to Subtotal "<Label name>".
For outer row labels in compact or outline course, y'all can display subtotals above or below their items, or hide the subtotals, by doing the following:
1. On the Design tab, in the Layout group, click Subtotals.
2. Do one of the following:
  - Select Practise Not Show Subtotals.
  - Select Evidence all Subtotals at Bottom of Group.
  - Select Show all Subtotals at Top of Group.

Display or hide grand totals for the entire report

You can brandish or hibernate the grand totals for the current PivotTable. Y'all can as well specify default settings for displaying and hiding thousand totals

Brandish or hibernate 1000 totals

Click anywhere in the PivotTable.
On the Pattern tab, in the Layout group, click M Totals, and so select the grand full display option that y'all desire.

Change the default behavior for displaying or hiding grand totals

Click the PivotTable.
On the Clarify tab, in the PivotTable group, click Options.
In the PivotTable Options dialog box, on the Totals & Filters tab, exercise i of the following:
- To display grand totals, select either Prove grand totals for columns or Prove one thousand totals for rows, or both.
- To hide 1000 totals, articulate either Show g totals for columns or Show 1000 totals for rows, or both.

Calculate the subtotals and 1000 totals with or without filtered items

Click anywhere in the PivotTable.
On the Analyze tab, in the PivotTable group, click Options.
In the PivotTable Options dialog box, on the Total & Filters tab, do one of the post-obit:
- For Online Analytical Processing (OLAP) source information, practice one of the following:
  - Select or clear the Subtotal filtered page items check box to include or exclude study filter items.
    
    Note:The OLAP data source must support the MDX expression subselect syntax.
  - Select or articulate the Marker totals with * bank check box to display or hide an asterisk next to totals. The asterisk indicates that the visible values that are displayed and that are used when Excel calculates the total are non the only values that are used in the calculation.
    
    Note:This choice is merely bachelor if the OLAP data source does not support the MDX expression subselect syntax.
- For not-OLAP source information, select or articulate the Allow multiple filters per field check box to include or exclude filtered items in totals.

Sentinel a video

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Subtotal row and column fields

In a PivotTable, select an item of a row or cavalcade field. Make sure it is a field and not a value.
On the Options tab, in the Active Field group, click Field Settings.

This displays the Field Settings dialog box.

In the Field Settings dialog box, nether Subtotals, do one of the following:

To subtotal an outer row or column label using the default summary role, click Automatic.
To remove subtotals, click None.

Note:If a field contains a calculated item, yous tin can't modify the subtotal summary function.

To use a unlike function, to display more than than one type of subtotal, or to subtotal an inner row or column label, click Custom (if this option is bachelor), and then select a function.

Functions that you tin use as a subtotal

Office	Description
Sum	The sum of the values. This is the default function for numeric data.
Count	The number of data values. The Count summary function works the same as the COUNTA function. Count is the default part for data other than numbers.
Boilerplate	The average of the values.
Max	The largest value.
Min	The smallest value.
Product	The product of the values.
Count Numbers	The number of data values that are numbers. The Count Numbers summary part works the aforementioned as the worksheet COUNT function.
StDev	An estimate of the standard departure of a population, where the sample is a subset of the unabridged population.
StDevp	The standard deviation of a population, where the population is all of the data to be summarized.
Var	An guess of the variance of a population, where the sample is a subset of the entire population.
Varp	The variance of a population, where the population is all of the data to be summarized.

Annotation:You cannot utilise a custom part that uses an Online Analytical Processing (OLAP) data source.

To include or exclude new items when applying a filter in which you accept selected specific items in the Filter bill of fare, select or clear the Include new items in manual filter bank check box.

Tips:

To quickly display or hide the current subtotal, right-click the item of the field, and then select or clear the check box next to Subtotal "<Label name>".
For outer row labels in compact or outline course, y'all can display subtotals above or below their items, or hide the subtotals, past doing the following:
1. On the Design tab, in the Layout grouping, click Subtotals.
2. Practice i of the following:
  - Select Do Not Show Subtotals.
  - Select Evidence all Subtotals at Bottom of Group.
  - Select Show all Subtotals at Top of Group.

Brandish or hide grand totals for the entire report

Y'all can brandish or hide the grand totals for the electric current PivotTable. You can also specify default settings for displaying and hiding grand totals

Display or hide grand totals

Click anywhere in the PivotTable.
On the Design tab, in the Layout group, click Grand Totals, and then select the chiliad total brandish option that y'all desire.

Modify the default behavior for displaying or hiding grand totals

Click the PivotTable.
On the Options tab, in the PivotTable group, click Options.
In the PivotTable Options dialog box, on the Totals & Filters tab, do one of the following:
- To display grand totals, select either Testify grand totals for columns or Prove grand totals for rows, or both.
- To hide grand totals, clear either Show grand totals for columns or Show grand totals for rows, or both.

Summate the subtotals and grand totals with or without filtered items

Click anywhere in the PivotTable.
On the Options tab, in the PivotTable grouping, click Options.
In the PivotTable Options dialog box, on the Full & Filters tab, do one of the following:
- For Online Analytical Processing (OLAP) source data, do 1 of the following:
  - Select or clear the Subtotal filtered folio items check box to include or exclude report filter items.
    
    Note:The OLAP data source must support the MDX expression subselect syntax.
  - Select or clear the Mark totals with * check box to display or hide an asterisk side by side to totals. The asterisk indicates that the visible values that are displayed and that are used when Excel calculates the full are not the only values that are used in the calculation.
    
    Note:This selection is just available if the OLAP data source does non back up the MDX expression subselect syntax.
- For not-OLAP source information, select or clear the Allow multiple filters per field check box to include or exclude filtered items in totals.

In Excel for the web, you tin can view PivotTable subtotals and totals if your workbook has PivotTables that show them. Nonetheless, you lot won't exist able to subtotal or total fields. You have to employ the desktop version in gild to exist able to piece of work with subtotals and totals. See Subtotal and total fields in a PivotTable.

Need more help?