The fact that you must correct these defaults in every pivot table that you create is annoying. Rather than cover each set of controls sequentially, this chapter covers the following functional areas in making pivot table customization: In Excel 2016, you find controls to customize a pivot table in myriad places: the Analyze tab, Design tab, Field Settings dialog, Data Field Settings dialog, PivotTable Options dialog, and context menus. These tweaks range from making cosmetic changes to changing the underlying calculation used in the pivot table.
In such cases, you can use many powerful settings to tweak pivot tables. Changing the Calculation in a Value FieldĪlthough pivot tables provide an extremely fast way to summarize data, sometimes the pivot table defaults are not exactly what you need.Customizing a Pivot Table’s Appearance with Styles and Themes.
