How to show grand total in Pivot Table

In a pivot table, the grand total represents the sum or total value of a specific data field across all the rows or columns in the table. It provides a comprehensive overview of the aggregated data. 

In this tutorial, we will learn how to show grand total in Pivot Table in Microsoft Excel. Grand total is a useful feature in Microsoft Excel that provides the sum of a specific instantly. Usually, grand total automatically appears when a pivot table is created however if not, then below mentioned are the steps you need to follow. 

Step 1 – Choose the Data 

• Choose the data to insert a pivot table. 

Step 2 – Locate the FIle Tab 

• Locate the File tab in the menu bar. 

Step 3 – Perform a Click on the PivotTable Button  

• Perform a click on the PivotTable button at the leftmost of the ribbon. 

Step 4 – Choose the New Worksheet Option 

• Choose the New Worksheet option in the dialog box that appear, you may insert the pivot table in the existing sheet if required. 

Step 5 – Select the Field to be Included in the PivotTable 

• Select the fields to be included in the PivotTable from the PivotTable Feilds pane at the right of the window. 

Step 6 – Now Click Anywhere on the Pivot Table 

• Perform a click anywhere on the pivot table. 
• This will activate the Design tab. 

Step 7 – Locate the Design Tab 

• Locate the Design tab in the menu bar. 

Step 8 – Perform a Click on the Grand Totals Drop-down Arrow 

• Perform a click on the “Grand Totals” drop-down arrow. 

Step 9 – Choose a Suitable Option 

• Choose a suitable option as per your data set. 
• In this case, we will choose the “On for Columns Only” option from the drop-down menu, since our sum of sales for all the products are listed in a column. 
• The Grand Total will appear in the pivot table.