Microsoft Office Tutorials and References
In Depth Information
Using the PivotTable Tools
Data. This section allows you to Refresh
your PivotTable (which goes and checks
the source data for changes since the
PivotTable was made or opened) and/or
to Change Data Source. If you opt for the
latter, the Change PivotTable Data Source
dialog box opens (see Figure 15-11),
allowing you to type or select a different
worksheet and/or range of cells to serve
as the data that builds your PivotTable.
Calculations. In this section of the
Options tab, you can Summarize your
PivotTable values (choose a function to
perform), display values in a variety of
numeric formats (as percentages of the
row, column, or grand total), or use the
Fields, Items, & Sets command to create
and edit calculated fields in your PivotTable.
Each of the commands opens an associated
dialog box.
Tools. This section offers the PivotChart
button (which you’ll use later in this
chapter), and access to OLAP (On Line
Analytical Processing) tools and What If
Analyses. These features go beyond the
scope of this topic, but you can find out
more about them at Microsoft’s Office 2010
Website at http://www.microsoft.com/
office/2010/en/excel/powerpivot/
default.aspx.
Figure 15-11
Pick a new source for your PivotTable’s data.
Actions. Use these three options (Clear,
Select, and Move PivotTable) to remove
data or filters, select any part of the table,
exclusive of everything else, or to literally
relocate your PivotTable to another
worksheet in your workbook (or another
workbook entirely). Each button has a
drop-down menu, offering you choices
for exactly what to Clear or Select, and
to where to move your PivotTable.
Show. This last section simply lets you
choose what you’ll see in your PivotTable
and the related workspace. All three
buttons should be highlighted (indicating
they’re “on”) by default, including display
of the Fields List (on the right side of the
workspace), +/– (Expand or Collapse)
buttons, and Field Headers. The buttons
all work as toggles—one click turns them
off, another turns them on.
 
 
Search JabSto ::




Custom Search