Right-click the heading of the row that you want the subtotal removed from.Select Field Settings from the menu list.Find the None option listed under Subtotals and click the radio button to select it.Click the OK button to remove the subtotals from your Pivot Table.
Instructions. Click the Start button in the lower-left hand part of the screen. Click Programs and open Microsoft Excel.. Open the Excel file that contains the worksheet with your saved pivot table. Click the worksheet tab at the bottom of the file to view your saved pivot table or create a new one. Right-click the heading of the row that you want the subtotal removed from. Select Field Settings from the menu list. Find the None option listed under Subtotals, and click the radio button to select it. Click the OK button to remove the subtotals from your Pivot Table.  Hide All Subtotals. In a new pivot table, when you add multiple fields to the Row Labels or column Labels areas, subtotals are automatically shown for the outer fields. In the screen shot below, there are two fields in the Row Labels area, and subtotals are shown at the top. Hide or Show One Subtotal. Instead of hiding all the subtotals, you can turn subtotals on or off for a specific pivot field. To hide the subtotal for a specific field, follow these steps. 1  Right-click one of the labels in the pivot field where you want to hide subtotals. How do I remove subtotals from a Pivot Table in Excel. NateDelahay asked on June 6, 2013. NA. NA. I have created a pivot table but cannot seem to delete the subtotals from it (See screen capture below) When I go to the Subtotals button in the Pivot Table ribbon, the only options are Show at top or Show at bottom. How to control subtotals in a pivot table. The default behavior of pivot tables is to automatically subtotal fields when they are added to row or column label areas. However, you can turn subtotals on and off on a field-by-field basis. Let’s take a look. As you first start to add Row or Column label fields to a pivot table, you won’t see any subtotals. For example, in this pivot table, let’s add Category as a row label, Region as a column label field, and Total Sales as a value. Notice we see grand totals, but no Show Subtotals at Top or Bottom. In a new pivot table, when you add fields to the Row Labels area, subtotals are automatically shown at the top of each group of items, for the outer fields. You canmove the subtota ls to the bottom of the group, if you prefer. To move the subtotals, follow these steps. Hide or Show One Subtotal. Instead of hiding all the subtotals, you can turn subtotals on or off for a specific pivot field. To hide the subtotal for a specific field, follow these steps. 1  Right-click one of the labels in the pivot field where you want to hide subtotals. In the Pivot Table Builder click the i icon @ the right end of the field name bar that the subtotals are based on. Then click the None option in the PivotTable Field dialog. [You can also get to the dialog if you right-click a cell in the subtotal field's column & choose Field Settings from the contextual menu. NateDelahay asked on June 6, 2013. NA. NA. I have created a pivot table but cannot seem to delete the subtotals from it (See screen capture below) When I go to the Subtotals button in the Pivot Table ribbon, the only options are Show at top or Show at bottom. You can control the subtotals that appear in the pivot table globally, or field by field. To work with subtotals all at once, navigate to the Design tab of the PivotTools ribbon, and use the Subtotals menu. You can disable all subtotals at once. Or, you can re-enable subtotals either at the top... As you first start to add Row or Column label fields to a pivot table, you won’t see any subtotals. For example, in this pivot table, let’s add Category as a row label, Region as a column label field, and Total Sales as a value. Notice we see grand totals, but no And in the Cell Styles gallery, the Total style. And you can see that I've now applied the Total style, to all of the subtotals in the Pivot Table. Now, let's remove the subtotals from the Pivot Table. To do that, I can right-click, on any genre. And notice that on the Shortcut menu, I can see Subtotal Genre, with a tick next to it. If I click: Subtotal Genre, the tick's removed and I can no longer see the subtotals.  Click on the text to navigate to the same place in the video. For this lesson, we need to open the sample file: Transactions-9, from your Sample Files folder. In this lesson, we'll add and remove subtotals, from a Pivot Table. And also apply formatting to Pivot Table fields. I'll begin this lesson by applying a filter, to show only the Biography and Thriller genres.  Instructions. Select your items, row, or column that you would like to subtotal in your pivot table report. Click Field Settings in the Active Field group on the Options tab. Click Automatic under Subtotals to subtotal the outer row or column label. 
http://www.ehow.com/how_6946785_remove-subtotals-pivot-table.html http://www.contextures.com/excel-pivot-table-subtotals.html http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/how-do-i-remove-subtotals-from-a-pivot-table-in/895dbb7d-e163-4049-a1e0-fcc42e9eef83 https://exceljet.net/lessons/how-to-control-subtotals-in-a-pivot-table http://www.contextures.com/excel-pivot-table-subtotals.html http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/how-do-i-remove-subtotals-from-a-pivot-table-in/895dbb7d-e163-4049-a1e0-fcc42e9eef83 https://exceljet.net/lessons/how-to-control-subtotals-in-a-pivot-table http://excelcentral.com/excel2013/expert/lessons/05150-add-and-remove-pivot-table-subtotals-and-grand-totals.html http://excelcentral.com/excel2007/expert/lessons/05110-add-remove-subtotals-and-apply-formatting-to-pivot-table-fields.html http://www.ehow.com/how_6913588_add-subtotal-pivot-table.html
how to completely remove subtotals in pivot table