Next, you have to choose which operation the subtotals should calculate.In the drop-down menu for “At each change in”, select the column that contains data you want to use for the subtotals.In the “Outline” section, click “Subtotal” to open the corresponding menu.Select Sort from the menu and sort the entire sheet by the column which contains the data you want to have subtotals of.Now click the “Data” tab from the top menu.Open the spreadsheet in which you want to add subtotals.When you’re done rearranging the data in your spreadsheet, you might want to add a new set of subtotals. Hopefully, you’ve managed to remove the subtotals using the guidelines from the previous two sections. Please note that if there’s a field in your pivot table that contains some calculations, you won’t be able to remove the subtotals.
![excel pivot table add subtotal to grandtotal excel pivot table add subtotal to grandtotal](https://pryormediacdn.azureedge.net/blog/2015/11/PivotTablePercentofTotal01.png)
In the “Subtotals” section, select “None”.In the “Field Settings” menu, click the “Subtotals & Filters” tab.In the “Active Field” section, click “Field Settings”.For older versions of Excel, click the “Options” tab.
![excel pivot table add subtotal to grandtotal excel pivot table add subtotal to grandtotal](https://wmfexcel.files.wordpress.com/2014/03/excel-tips-sum-vs-subtotal1.png)
In older versions of Excel (Excel 2013 and earlier), you’ll see the “Options” and “Design” tabs without the “PivotTable Tools” title above them. It will appear in the top menu, right next to the “View” tab, and will contain two tabs: “Analyze” and “Design”.
![excel pivot table add subtotal to grandtotal excel pivot table add subtotal to grandtotal](https://i.stack.imgur.com/qCS93.png)
Now click the “Clear Outline” option to remove any grouping for that spreadsheet.In the “Outline” section, click the “Ungroup” drop-down menu.If you don’t want to delete the subtotals, but want to remove all groups to further rearrange your data, do the following: This will ungroup all the data in the spreadsheet, effectively removing any subtotal rows you might have there.In the “Subtotal” menu, click the “Remove All” button.In the “Outline” section of the top menu, click “Subtotal”.Open the Excel spreadsheet you want to edit.Whether you simply want to remove subtotal rows from your spreadsheet or reorganize the entire sheet, the process is basically the same. Removing Subtotals from Standard Spreadsheets