excel how to remove subtotals from pivot table

Select one of the Category subtotal labels, such as Cookies Total, in cell C5.To remove the subtotal labels for the Category column, follow these steps: Here are a couple of tips to help you clean up pivot table subtotals, to make the data easier to read.įor example, this pivot table is in Tabular layout, with subtotals showing for the District and Category fields, at the bottom of each group.Ĭolumn C looks cluttered, because the subtotals are close together, and it’s hard to see the category names. The pivot table layout can look cluttered if there are too many subtotals, especially if they are close together. Click on any Cell in the Pivot Table and you will see 2 new tabs (Analyze & Design) appearing on the top menu bar.Ģ. Click on the Design Tab > click on Grand Totals and select On for Columns Only option in the drop-down menu.When there are multiple row fields in a pivot table, the outer fields automatically show subtotals. Since, this is not necessary in our case, we are going ahead with the following steps to remove Row Grand Totals in Pivot Table.ġ. Hide Column or Row Grand Totals in Pivot TableĪs you can see in the image below, we have a Pivot Table showing both Row and Column grand totals. This will totally remove Grand Totals from your Pivot Table and the Pivot Table will only indicate the subtotals. Since, we are only interested in tracking the individual sales made by the two stores, we are going ahead with the following steps to remove Grand Total in this pivot table.ġ. Click on any Cell in the Pivot Table and you will see 2 new tabs (Analyze & Design) appearing on the top menu bar.Ģ. Next, click on the Design tab > click on Grand Totals and select OFF for Rows and Columns option in the drop-down menu. Steps to Remove Grand Total in Pivot TableĪs you can see in the Pivot Table below, we have the “Subtotals” for products sold by Store#1 and Store#2 and also the “Grand Total” of all the Products sold by the two Stores.

Excel how to remove subtotals from pivot table