PivotTable Fields and Functions

Field button

A button on a PivotChart with an arrow to choose a filter and thus change the data that is displayed in the chart

Filtering button

A button on a slicer used to select the item by which to filter

Area section

The lower portion of the PivotTable Fields pane

Clear Filter

A button that removes a filter

PivotChart

A graphical representation of the data in a PivotTable report

Data model

A method of incorporating data from multiple, related tables into an Excel worksheet

List

A series of rows that contains related data with column titles in the first row

Field

A single piece of information for every record

PivotTable Fields pane

A window that lists all of the fields—column titles—from the source data for use in the PivotTable

Record

All of the categories of data pertaining to one person, place, event, thing, or idea

Filters area

An area in the lower portion of the PivotTable Fields pane to position fields by which you want to filter the PivotTable report

Values area

An area to position fields that contain data that is summarized in a PivotTable report or PivotChart report

PivotTable

An interactive Excel report that summarizes and analyzes large amounts of data

Slicer

Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data

Associated PivotTable report

The PivotTable report in a workbook that is graphically represented in a PivotChart

Field names

The column titles from source data that form the categories of data for a PivotTable

Refresh

The command to update a PivotTable to reflect the new data

Source data

The data for a PivotTable, formatted in columns and rows, that can be located in an Excel worksheet or an external source

Primary key

The field used to uniquely identify a record in an Access table

Slicer header

The top of a slicer that indicates the category of the slicer items

Field section

The upper portion of the PivotTable Fields pane containing the fields—column titles—from your source data

Filter

To limit the display of data to only specific information

Columns area

An area to position fields that you want to display as columns in the PivotTable report

Rows area

An area to position fields that you want to display as rows in the PivotTable report

Relationship

An association between tables that share a common field