How to display PivotTable subtotals in Microsoft Excel?

To summarize the data in Microsoft Excel we can use PivotTable tools feature. With the help of this feature we can display the data into most readable form. One of the interesting option it provides is showing the totals of each group which will be helpful to find out the group wise sum of the provided data. This article explains how to display subtotals in PivotTable.

This article applies to:

  • Microsoft Office 2010.

Step (1). Select the PivotTable. Microsoft Excel displays Pivot Table Tools menu with Options and Design tabs.

Pivot Table Tools

Pivot Table Tools

Step (2). Click on Design Tab. It will display all the design controls.

Step (3). Click on Subtotals icon which is under Layout group. It will display a pull down menu.

Pivot Table Subtotals

Pivot Table Subtotals

Step (4). Select Show all Subtotals at Top of Group menu item.

Now subtotals will be displayed along with group in PivotTable. Below picture displays the subtotals of each Year group. For 2005 it is $99.63, for 2007 it is $11.94 etc.,.

Pivot Table Subtotals (Group)

Pivot Table Subtotals (Group)

by Code Steps

Leave a Reply