CST-MODULE 4

Layout section

The lower portion of the PivotTable Fields pane containing the four areas for layout; use this area to rearrange and reposition fields in the PivotTable.

PivotTable Fields Pane

A window that lists, at the top, all of the fields—column titles—from the source data for use in the PivotTable report and at the bottom, an area in which you can arrange the fields in the PivotTable.

Field section

The upper portion of the PivotTable Fields pane containing the fields—column titles—from your source data; use this area to add fields to and remove fields from the PivotTable.

Values area

An area to position fields that contain data that is summarized in a PivotTable report or PivotChart report. The data placed here is usually numeric or financial in nature and the data is summarized—summed. You can also perform other basic calculations such as finding the average, the minimum, or the maximum.

Filters area

An area to position fields that you want filter the PivotTable, enabling you display a subset of data in the PivotTable report

Columns area

An area to position fields that you want to display as columns in the PivotTable report. Field names placed here become column titles, and the data is grouped in columns by these titles.

ROWS area (Pivot Table)

An area to position fields that you want to display as rows in the Pivottable report. Fields names placed here become row titles, and the data is grouped by these row titles