Microsoft Office Tutorials and References
In Depth Information
on its own page offers the most flexibility and minimizes the likelihood that it will
inadvertently interfere with the contents of an existing worksheet.
After your PivotTable is created, you’ll see a blank layout like the one shown in Figure
12-11. On the right side is the PivotTable Field List pane, whose contents mirror the
headings in your source data table or range. Two new tabs are also visible at the end of the
ribbon, under the PivotTable Tools heading.
Figure 12-11 Build a new PivotTable from scratch by selecting fields from the list on the right
and adding each one as row or column labels, values, or filters.
As you click to select fields from the list in the top of the pane, Excel adds each selected
field to one of the four sections in the bottom of the pane. The program makes its best
guess as to which field goes where, although you can override the default section
assignment for any field by dragging it to a different box. Excel also assigns a default calculation
type to the value fields. You can accept the defaults or tweak these settings, as we explain
shortly. Figure 12-12 shows a simple PivotTable that starts with 1,095 data points (one for
each day of the year for each of three weather stations) and summarizes it into monthly
average precipitation amounts arranged by location.