# 2.3.1 Add Subtotal to a Specific Field; Practice Exercise 10 – Intro to Excel 2016 Pivot Tables

Practice Exercise 10: Add a Subtotal to a specific field of a pivot table.
Still use the data file, RANGE TO TABLE TO PIVOT TABLE2.
STEP 1:  Select any cell in the pivot table. Select the Design tab on the Ribbon, as shown below (FIGURE 1). ​​​

FIGURE 1
 STEP 2: ​In the Ribbon Layout section, select the Report Layout icon, Show in Outline Form (FIGURE 2). FIGURE 2
 ​STEP 3: In the Ribbon Layout section, select the Subtotals icon on the left end of the Ribbon. On the drop-down menu, select the choice, Do Not Show Subtotals (FIGURE 3). FIGURE 3
 STEP 4: ​Up in the Ribbon, select the PivotTable Analyze tab (FIGURE 4). FIGURE 4
 STEP 5: ​To only add Subtotals to the Months, select the Month field (FIGURE 5). FIGURE 5
 STEP 6: ​In the Active Field section of the Ribbon, select the Field Settings icon (FIGURE 6). FIGURE 6
 ​STEP 7: In the Field Settings dialog box, in the Subtotals section select the radio button choice, Automatic. Then select the OK button (FIGURE 7). FIGURE 7
STEP 8: The result of selecting the Month field only for a Subtotal is shown below (FIGURE 8). Observe that only the Months Jan, Feb, Mar are subtotaled,
FIGURE 8
 STEP 8A. You can also do a Month field only Subtotal by doing a right-button mouse click on the Month field in the Rows quadrant, and in the Field Settings dialog box, change the Subtotal choice to “Automatic” (FIGURE 9) . FIGURE 9
 STEP 8B. ​You can also do a Month field only Subtotal by doing a right-button mouse click on the Month field and select “Subtotal Month” on the mouse shortcut menu (FIGURE 10). FIGURE 10
 STEP 9: ​To remove the specific-field subtotaling for the Month field, select the Month field once again (FIGURE 11). ​ ​​Up on the Ribbon locate where the Active Field, Month is located and select Field Settings below it (FIGURE 12). FIGURE 11                                                                FIGURE 12
 STEP 10: ​In the Field Settings dialog box, in the Subtotals section select the radio button choice, None. Then select the OK button (FIGURE 13). FIGURE 13
 STEP 11: ​TURN SUBTOTALS BACK ON. Select Subtotals – Show All Subtotals at Top of Group (FIGURE 14). FIGURE 14
This is the end of the section. To continue go to Module 2 Section 2.4 Change Grand Totals, Insert Blank Lines, Repeat All Items Labels; Practice Exercises 11-13