# Lesson 7

Preview

Add a Subtotal to a Specific Field; Practice Exercise 9

Practice Exercise 9: Add a Subtotal to a specific field of a pivot table.

Continue to 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). ​​​

STEP 2: ​In the Ribbon Layout section, select the Report Layout icon, Show in Outline Form (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 choiceDo Not Show Subtotals (FIGURE 3).

STEP 4: ​Up in the Ribbon, select the PivotTable Analyze tab (FIGURE 4).

STEP 5: ​To only add Subtotals to the Months, select the Month field (FIGURE 5).

STEP 6: ​In the Active Field section of the Ribbon, select the Field Settings icon (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).

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,

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) .

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).

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).

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).

STEP 11: ​TURN SUBTOTALS BACK ON. Select Subtotals – Show All Subtotals at Top of Group (FIGURE 14).

END OF LESSON

Back to: Intro to Excel 2016 Pivot Tables > Module 2 – Intro to Excel 2016 Pivot Tables