how to remove subtotals from pivot table macro excel 365

With either option, you may want to add in blank lines after each grouping item using the Blank rows menu. Or, you can re-enable subtotals either at the top.īoth commands enable all subtotals, but they each put the subtotals in a different location. To work with subtotals all at once, navigate to the Design tab of the PivotTools ribbon, and use the Subtotals menu. You can manage the subtotals that appear in the pivot table globally or field by field. If we add City under Region, we’ll see subtotals for each Region appear as new columns in the pivot table. As a general rule, the inner-most field in the row labels area, in this case, Product, will not be subtotaled, while outer fields, Category, in this case, will be subtotaled. However, if we add a second field to the Row labels area, Product, we’ll see a subtotal for each category appear as a row in the table. Notice we see grand totals, but no subtotals. For example, in this pivot table, let’s add Category as a row label, and Region as a column label field, and Total Sales as a value. When you first add Row or Column labels to a pivot table, you won’t see any subtotals. However, you can turn subtotals on or off on a field-by-field basis. The default behavior for pivot table is to automatically subtotal fields when they are added to row or column label areas.

How to remove subtotals from pivot table macro excel 365