How to Show Grand Total in Pivot Table: 3 Methods

Are you looking for ways to show grand totals in your Pivot Table? In this article, we will discuss three methods to achieve this. With the help of these methods, you can easily display grand totals in your Pivot Table and make your data analysis more efficient.

Method 1: Using Grand Totals Feature

The first method is to use the Grand Totals feature in your Pivot Table. To do this, follow these steps:

* Select any cell in your Pivot Table.

* Go to the Design tab in the ribbon.

* Click on the 'Grand Totals' button in the 'PivotTable Style Options' group.

* Select 'On for Rows and Columns' from the dropdown menu.

This will automatically create a grand total row and column in your Pivot Table, showing the total values for each category.

Method 2: Manually Creating Grand Totals

The second method is to manually create grand totals by dragging fields to the relevant groups. To do this:

* Select any cell in your Pivot Table.

* Go to the 'PivotTable Fields' pane and drag the 'Year' field to the 'Column group'.

* Drag the 'Sales' field to the 'Values group'.

* Drag the 'Product' field to the 'Rows group'.

This will create a grand total row for each category in your Pivot Table.

Method 3: Using Grand Totals Feature with New Worksheet

The third method is to use the Grand Totals feature with a new worksheet. To do this:

* Go to the 'PivotTable Fields' pane and select 'New Worksheet'.

* Click on the 'OK' button.

* Select the entire dataset by clicking on cell B4 and pressing the CTRL+SHIFT+Down arrow.

* Go back to the PivotTable group and select 'From Table/Range'.

* A PivotTable from table or range dialog box will pop up. Select the entire dataset and click on the 'OK' button.

This will create a new worksheet with your Pivot Table, including grand totals for each category.

In conclusion, showing grand totals in your Pivot Table can be achieved through three methods: using the Grand Totals feature, manually creating grand totals, or using the Grand Totals feature with a new worksheet. By following these steps, you can easily display grand totals in your Pivot Table and make your data analysis more efficient.

GrandTotal download