• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Office
Home » Excel » How to Add or Remove Subtotals in Pivot Table

How to Add or Remove Subtotals in Pivot Table

By: Waseem Patwegar

Adding Subtotals to Pivot Table provides an additional level of breakdown, which can be useful. You will find below the steps to add or remove subtotals in Pivot Table.

Add or Remove Subtotals in Pivot Table

1. Remove Subtotals in Pivot Table

In the Pivot Table below, we have “Grand Total” for all the products sold and also the “Subtotals” for products sold by Store#1 and Store#2.

Pivot Table Showing Subtotals

Since, we only have 2 stores, the subtotals look good and provide additional information.

However, as you add more stores to the report, the number of subtotals will also grow and this may end up making the report look crowded.

In such a case, you may find it necessary to get rid of the subtotals, in order to make your report look clean and easy to follow.

1. Right-click on the Store Entry and click on Field Settings option in the contextual menu that appears.

Access Field Settings to Remove Subtotals in Pivot Table

2. On the Field Data Settings screen, select the None option and click on the OK button.

Remove Subtotals From Pivot Table

This will remove the Subtotals for Store#1 and Store#2 and the Pivot Table will only indicate the Grand Total of items sold by both the stores.

2. Add Subtotals in Pivot Table

Depending on your requirements, you may find the need to show Subtotals in Pivot Table. In such a case, you can follow the steps below to Add Subtotals in Pivot Table.

1. Right-click on the Store Entry and click on Field Settings option in the contextual menu.

Access Field Data Settings to Add Subtotals in Pivot Table

2. On the next screen, select the Automatic option and click on OK to Add Subtotals in Pivot Table.

Pivot Table Showing Useful Subtotals

As you can see in the image above, adding subtotals in Pivot Table has made the report look more useful by providing both summary of items sold by each store and also the Grand Total of all the items sold.

Related
  • How to Create Pivot Table From Multiple Worksheets
  • How to Create Two Pivot Tables in Single Worksheet

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar

Twitter
Facebook



Popular Now

  • How to Reduce Cellular Data Usage on iPhone
  • How to Backup Registry in Windows 11/10
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Create Local Account in Windows 11



Gadget Guide

  • Mac vs PC Comparison: Should You Buy Mac or PC
  • Chromebook vs Windows Laptop
  • Kindle E-Reader Comparison | Which Kindle to Buy
  • iPad vs iPad Pro Comparison
  • Advantages of Chromebooks

About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2022 @Techbout.com · All Rights Reserved