Open the workbook that contains the pivot table. You can base the defaults on that pivot table. The second way to set the defaults is useful if you have a pivot table that’s already in the correct format. Totals appear at the bottom of each group. Note that you now have useful headings in A4, B4, and C3. The next time that you create a pivot table, your settings will appear in the pivot table as shown in Figure 2. In the PivotTable Options dialog, type a zero (0) for the setting called For Empty Cells, Show. Change the Subtotals option to Show Subtotals At the Bottom of the Group. Choose the checkbox for Repeat All Item Labels. Open the Report Layout dropdown and choose Show in Tabular Form. Click the button for Edit Default Layout. The first item should be Make Changes to the Default Layout of Pivot Tables. The new feature lets you set the default layout for your pivot tables. Subtotals appear at the top of each group instead of the bottom. Multiple fields in the Rows area are all collapsed into column A with a generic heading of “Row Labels.” Empty cells appear in the pivot table as blank instead of zero. In the past, pivot tables were created in the Compact layout shown in Figure 1.
