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