Home > Articles

Customizing Fields in a Pivot Table

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

In this chapter

  • The Need to Customize

  • Displaying the PivotTable Field Dialog Box

  • Customizing Field Names

  • Applying Numeric Formats to Data Fields

  • Changing Summary Calculations

  • Adding and Removing Subtotals

  • Using Running Total Options

The Need to Customize

As you build your pivot table reports with the PivotTable Wizard, Excel is busily adding fields and performing calculations in the background.

The wizard is designed to always sum numeric data and to always count text data. The wizard allows you to produce a standard pivot table in a few seconds. However, sometimes the PivotTable Wizard doesn’t quite hit the mark.

A common problem is that Excel chooses to count data that you wanted summed. This can happen when your numeric data inadvertently contains a single blank or text cell mixed in.

Sometimes, you want to create something other than the default pivot table. In addition to Sum and Count, Excel offers a total of 11 subtotal options that can be used separately or in combination. You can combine these with nine different running total options. That makes for 5,621 different ways to present each data field in the pivot table.

You can step in and take control of the calculations by customizing the pivot table. Customizations are controlled in the PivotTable Field dialog box.

  • + Share This
  • 🔖 Save To Your Account