Microsoft Office Tutorials and References
In Depth Information
Create a
PIVOTTABLE
The PivotTable layout consists of several elements:
report filters, data, columns, and rows. Use the
PivotTable Field List to organize the elements. When
working with a PivotTable, you can bring the Field
List into view by clicking anywhere in the PivotTable,
clicking the Options tab, and then clicking Field List.
To construct a PivotTable, choose the fields you want
to include in your report and then drag fields from
the PivotTable Field List into the Report Filter, Column
Labels, Row Labels, and Σ Values boxes. You can click
and drag more than one field into an area. Report
Filter fields enable you to filter the data that appears
in your report. Row Label fields show as row labels
down the left side of your PivotTable, and Column
Label fields show as column labels across the top of
your PivotTable. Place your continuous data fields in
the Σ Values box. Fields placed in the Σ Values box
make up the data area. You can sort and filter your
PivotTable column and row data, and you can arrange
and rearrange field layouts.
7
Click to select the fields you want
to include in your PivotTable
(
changes to
).
7
8
Click and drag fields among the
Report Filter, Column Labels,
Row Labels, and Σ Values boxes.
If you want to filter what displays
in a PivotTable page, click and
drag the field you want to filter
by to the Report Filter box.
l
Click and drag fields you want
to display as columns to the
Column Labels box.
l
8
Click and drag fields you want
to display as rows to the Row
Labels box.
l
Click and drag fields you want
to display as data to the Σ Values
box.
l
112
 
Search JabSto ::




Custom Search