Subtotals and Grand totals in Excel Pivot tables

In this post, you will learn how to add Subtotals and Grand totals in Excel pivot tables and how to use it with-in your excel spreadsheet.

Subtotals and Grand totals in Excel Pivot Tables

A pivot table normally summarizes the given values and displays them at the grand total field. The summarizing functions can be changed from the value field settings.

Now, let’s see how to add subtotals and grand totals manually.

Look at the following example,

Subtotals and Grand totals in Excel Pivot tables

The sales report of a firm is given in the form of nested fields in the pivot table.

To add the sub total field to the table,

Click on the subgroup of the table and on the Options tab click on Field settings.

Subtotals and Grand totals in Excel Pivot tables

This will display the field settings tab and on the Subtotals section check the automation option.

Subtotals and Grand totals in Excel Pivot tables

Click ok

Now click the sub group and click the design tab in the ribbon.

The first two options or icons available in design ribbon are Subtotals and Grand totals.

Subtotals and Grand totals in Excel Pivot tables

First click on subtotals and in the drop down menu choose the orientation of the subtotals that needs to be displayed.

Subtotals and Grand totals in Excel Pivot tables

Select an option and the subtotal is displayed on the pivot table.

Subtotals and Grand totals in Excel Pivot tables

Now click the Grand totals drop-down and choose an option from it.

Subtotals and Grand totals in Excel Pivot tables

The pivot table shows the grand totals depending on the option you selected.

Subtotals and Grand totals in Excel Pivot tables

You can see that, the grand total is displayed at the bottom of the Pivot table.

Subtotals and Grand totals in Excel Pivot tables
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.