Home > Articles > Home & Office Computing > Microsoft Applications

Customizing Fields in a Pivot Table

  • Print
  • + Share This
Creating a pivot table in Excel is a snap with the PivotTable wizard, but sometimes you'll need finer control over the function and relation of fields. This chapter teaches you how to customize fields to do precisely what you want them to using the PivotTable Field dialog box.
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