Microsoft Office Tutorials and References
In Depth Information
The default name for that field reflects the type of calculation. You can change it to a
more descriptive name, such “Total Rainfall” in place of “Sum of Precipitation.” You can
also choose a different calculation. So, from a list of individual sales, you could choose the
Sales_Amount field and click Count to calculate how many transactions each sales person
had during a comparable period. Or choose Sum or Average to calculate the total sales
amount or the average sale per transaction, respectively.
Click the Number Format button to display the Format Cells dialog box, with only the
Number tab available. You can apply any number or date format, set the number of
decimal places, and specify whether you want to use a thousands separator. This dialog box is
available for value fields only.
The corresponding option for fields in the Filter, Row Labels, and Column Labels sections is
Field Settings. The contents of the Field Settings dialog box are significantly different from
those available for value fields, as shown here. We look at these options in more detail in
the next section.
INSIDE OUT Customize the PivotTable Field List pane
In the upper right corner of the PivotTable Field List pane is a small, unlabeled button
with an arrow to its right (see Figure 12-13). Clicking that button reveals a menu of five
alternative arrangements of the two sections. You can arrange fields and areas side by
side or show only one section while hiding the other. For most simple PivotTables, the
default layout is good enough. Consider changing the layout if you have a complex
data source with many fields.