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 choice, Do 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
Leave a Reply