Exam 77-427 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.2   Create and Manage PivotTables: Format Data (Subtotals) Design Layout: Subtotals By default, a PivotTable displays the Subtotals at the top of a Group. You can change the Layout with the PivotTable Design Ribbon. Here are the steps: Before You Begin: Select the PivotTable. The PivotTable Tools should be available. 2. Try it: Change The Subtotal Layout Go to PivotTable Tools ->Design. Go to Layout-> Subtotals. Select: Show all Subtotals at Bottom of Group.   What Do You See: The Subtotal options include the following: Do Not Show Subtotals Show all Subtotals at Bottom of Group Show all Subtotals at Top of Group Include Filtered Items in Totals Keep going...

PivotTable Tools ->Design-> Layout-> Subtotals