A macro can simply remove all the Subtotal fields from a Pivot Table. VBA Macros are effective when we need specific outcome-oriented results.
Method 4: Using VBA Macro to Remove Subtotal in Pivot Table
#How to remove subtotals from pivot table macro excel 365 how to
Read More: How to Use SUBTOTAL in Excel with Filters (With Quick Steps) ? Afterward, Excel displays all the fields except Subtotal of the Cities in the Pivot Table. ➧ Choose the Subtotals & Filters section (in case Excel automatically doesn’t select).
Step 2: The Field Setting window appears. Otherwise, Excel displays Value Field Setting in case you Right-Click on Value entries. ? Alternatively, you can Right-Click on any City cell entries (i.e., Subtotalof whom) to bring out the Context Menu with Field Setting in its options similar to the screenshot below. Step 1: Select the PivotTable Analyze tab > Click on Field Setting (in the Active Field section). We can use the Pivot Table Analyze tab to alter the Field Settings. Method 3: Remove Subtotal in Pivot Table Using Field Setting OptionsĪs we said earlier Excel shows two Extra tabs PivotTable Analyze and Design to further modify the Pivot Tables. ? Within seconds Excel removes Subtotal fields from the Pivot Table as depicted in the below image. From the Context Menu, Deselect the Subtotal City option. We can unselect the option to remove the Subtotal entries. If we Right-Click on any City entries, we see multiple options and Subtotal City will be one of them. Method 2: Remove Subtotal by Deselecting Context Menu Option Step 2:After selecting Do Not Show Subtotals, Excel removes all the Subtotal fields from the Pivot Table as shown in the below picture. Go to Design > Click on Subtotal > Select Do Not Show Subtotals (from the Subtotal options). Step 1: Excel shows the Design tab whenever you select a cell within the Pivot Table. From there we can choose the offered options not to show Subtotal in the Pivot Table entries. Pivot Table provides a Subtotalsection in the Design tab. Method 1: Using Pivot Table Design Tool to Remove SubtotalĮxcel displays PivotTable Analyze and Design tab whenever we work with the Pivot Table. We’ll use these two tabs in our latter section to remove the Subtotal entriesfrom Pivot Table. Excel offers multiple options to alter Fields, Display, or Orientation of a Pivot Table. While working with Pivot Table, every time we place the mouse cursor within the Pivot Table, Excel shows PivotTable Analyze and Design tab along with the other tabs.
Remove Subtotal from Pivot Table Entries.xlsmĥ Easy Ways to Remove Subtotal in Pivot Table