To summarize the data in Microsoft Excel we can use the PivotTable tools feature. With the help of this feature, we can display the data into the most readable form. One of the interesting options 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 the Pivot Table Tools menu with Options and Design tabs.
Step (2). Click on Design Tab. It will display all the design controls.
Step (3). Click on the Subtotals icon which is under the Layout group. It will display a pull-down menu.
Step (4). Select Show all Subtotals at Top of Group menu item.
Now subtotals will be displayed along with the group in PivotTable. The below picture displays the subtotals of each Year group. For 2005 it is $99.63, for 2007 it is $11.94 etc.,.
One thought on “How to display PivotTable subtotals in Microsoft Excel?”