I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. Instantly, you see Excel removes the Subtotal Row (i.e., Row Number 7). On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons. Within seconds Excel removes Subtotal fields from the Pivot Table as depicted in the below image. A drop-down appears. Firstly check, via the Pivot table toolbar, that Enable Selection is on. Here's the code for removing all totals and then re-adding the column totals (bottom row) only: Sub removetotal () With ActiveSheet.PivotTables ("PivotTable1") .ColumnGrand = False .RowGrand = False End With ActiveSheet.PivotTables ("PivotTable1").ColumnGrand = True End Sub Report abuse Was this reply helpful? In pivot tables, you can also add labels to column totals and subtotals. > The rows are data for each date. The Max of Date value doesn't need any subtotals of grand totals. Enable multiple filters in the PivotTable Options dialog box. Otherwise a space will be at the end of your cell. We will create a column with random numbers that are ranging from 1 to 20 and will call it simply Numbers".We will change the sheet name to Colors and Numbers" as well. If you don't want to delete the subtotals, but want to remove all groups to further rearrange your data, do the following: The first 6 rows are sums, the last three are averages. 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 the Totals & Filters tab. On the Data tab, in the Outline group, click Subtotal. Amount field to the Values area (2x). However, looking at the data, perhaps this standard pivot trick will do: do not sum but use min or max. Levels in the pivot table will be stored in MultiIndex objects (hierarchical indexes) on the index and columns of the result DataFrame. However, I was able to fix the unwanted bold font by clicking within the pivot table, going to design in the ribbon bar, and within PivotTable Style Options - unclick the row headers box. Show or hide subtotals Click anywhere in the PivotTable to show the PivotTable Tools. In the next connected section [Values], change test color to white. At first I thought it was a design element to the table. title=">