Courses / PivotTables & PivotCharts
4. PivotTable Field List
The interface showing available fields and the four areas (Filters, Columns, Rows, Values) for placing them.
PivotTables (Excel)
PivotTable Field List
The Field List is the pane that shows your table fields and the four areas (Filters, Columns, Rows, Values) where you drop them to build a PivotTable.
"I want to turn this messy table into a quick summary without writing formulas."
The Field List shows all source columns and four drop zones — Filters, Columns, Rows, Values — that determine how data is grouped, filtered and aggregated in the PivotTable.
"I want to turn this messy table into a quick summary without writing formulas."
The Field List shows all source columns and four drop zones — Filters, Columns, Rows, Values — that determine how data is grouped, filtered and aggregated in the PivotTable.