Microsoft Office Tutorials and References
In Depth Information
You can create the formula manually by typing it or by double-clicking items in the
Fields list box. Double-clicking an item transfers it to the Formula field. Because the
Units Sold field contains a space, Excel adds single quotes around the field name.
After you create the calculated field, Excel adds it to the Values area of the pivot table (and it also appears in the
PivotTable Field task pane). You can treat it just like any other field, with one exception: You can't move it to
the Rows, Columns, or Filter areas. It must remain in the Values area.
Figure 18-35 shows the pivot table after adding the calculated field. The new field displayed Sum of Avg Unit
Price, but I changed this label to Avg Price.
Figure 18-35: This pivot table uses a calculated field.
The formulas that you develop can also use worksheet functions, but the functions
can't refer to cells or named ranges.
Inserting a calculated item