Microsoft Office Tutorials and References
In Depth Information
Create a PivotTable
Within a PivotTable, you can create new fields, called
calculated fields , which you base on the values in
existing fields. You create a calculated field by
performing simple arithmetic on every value in the
existing column. Your formula can include functions;
operators such as +, –, *, and /; and existing fields,
including other calculated fields.
You usually use calculated fields with continuous
data such as incomes, prices, miles, and sales. For
example, you can multiply each value in a field called
Price by a sales tax rate to create a calculated field
called Tax. Use the Insert Calculated Field dialog box
to name your calculated field and create the formula
you want to use. You can also use this dialog box to
modify existing calculated fields or delete fields you
no longer want to use.
Your calculated fields are available in the PivotTable
Field List for use in your PivotTable. You can use the
values in the calculated field only in data cells.
Click any field in your
The PivotTable tools become
Click the Options tab.
Click Field List.
The PivotTable Field List
A menu appears.
Click Calculated Field.