Microsoft Office Tutorials and References
In Depth Information
l The Insert Calculated
Field dialog box
appears.
6
Type a name for the
new field.
7
Double-click an existing
field to use in defining
the field.
6 8
8
Type an operator and
the value, such as
*1.05 .
7
9
Click OK.
9
l Values for the calculated field fill the data
area.
l The calculated field appears at the end of
the Field List.
Did You Know?
You can use the Value Field Settings dialog box
to change the name of your field headers. Open
the Value Field Settings dialog box and type a
new name in the Custom Name field. To remove
field headers from your PivotTable, click the
Options tab on the Ribbon and then click Field
Headers to toggle off the field headers.
Did You Know?
You can change your data source. Click
anywhere in your PivotTable to activate the
PivotTable tools. On the Ribbon, click Options
and then click Change Data Source. The Change
PivotTable Data Source dialog box appears.
Select a new table or range or change the
external data source.
Chapter 5: Explore the Patterns in Your Data
119
 
Search JabSto ::




Custom Search