Midlands Microsoft Office Provider

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.

Picture

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