Microsoft Office Tutorials and References

In Depth Information

A workbook that demonstrates calculated fields and items is available at this topic's

website. The file is named calculated fields and items.xlsx.

Figure 18-33 shows a pivot table created from the data. This pivot table shows Sales (Values area), cross-tabu-

lated by Month (Rows area) and by SalesRep (Columns area).

Figure 18-33:
This pivot table was created from the sales data.

The examples that follow create

• A calculated field, to compute average sales per unit

• Four calculated items, to compute the quarterly sales commission

Creating a calculated field

Because a pivot table is a special type of range, you can't insert new rows or columns within the pivot table,

which means that you can't insert formulas to perform calculations with the data in a pivot table. However, you

can create calculated fields for a pivot table. A
calculated field
consists of a calculation that can involve other

fields.