Session 5.3
Layout area for a Pivot Table: Report filter
A field used to filter the report by selecting one of more items, enabling you to display a subset of data in a Pivot Table report
Fields in the report filter area create
A filtered view of the Pivot Table, showing summarized data in the report
A Pivot Chart
A graphical representation of the data in a pivot table
A PivotTable is
An interactive table used to group and summarize either a range of data or an excel table into a concise, tabular format for easier reporting and analysis
A slicer is
An object used to filter a Pivot Table or Pivot Chart. You can create more than one slicer for a Pivot Table or Pivot Chart
The Pivot Table uses the data from the Category field as
Column labels
Category fields are the fields that
Group the values in a Pivot Table, such as condition. location, and year acquired
Values fields
The fields that contain summary data in a Pivot Table. This Pivot Table uses the total of the Appraised Value as the values fields (tutorial 5.3)
Category fields are
The fields that group the values in a Pivot Table. Category fields appear in Pivot Tables as row labels, column labels, and report filters
Layout area for a Pivot Table: Column labels
The fields you want to display as columns at the top of the Pivot Table. One column is displayed for each unique item in this area. You can have nested column fields
Layout area for a Pivot Table: Row labels
The fields you want to display as the rows in the Pivot Table. One row is displayed for each unique item in this area. You can have nested row fields
Layout area for a Pivot Table: Values
The fields you want to summarize
The Pivot Chart Tools contextual tabs enable you to
Manipulate and format the selected PivotChart the same way as an ordinary chart
Compact report layout
Places all fields from the row area in a single column and indents the items from each field below the outer fields.
You can add many levels of
Subtotals and totals to a Pivot Table
Fields in the Values area are
Summarized in the Pivot Table
Fields that contain summary data are called
Value fields
Collapse button indicates
You can hide details for that item
The expand button indicates
You can show more details for that item
This Pivot Tables uses the data from the
Location field as row labels
Fields in the column labels area are
Displayed as columns at the top of the Pivot Table
Fields in the row levels area are
Displayed as rows in the Pivot Table
Filtering a field lets you
Focus on a subset of items in that field
A Pivot Chart allows you to
Interactively add, remove, filter and refresh data fields in the Pivot Chart similar to working with a Pivot Table.