O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learning the PivotTable Lingo

Here is some PivotTable lingo that you need to know before you work with pivot tables.

  • Item— An item label is a subcategory of a PivotTable field and is derived from unique entries in a database field or in a list column. Items appear as row or column labels or in the lists for page fields in a pivot table report.

  • Row field— Row field labels have a row orientation in a pivot table report and are displayed as row labels. Appears in the ROW area of a pivot table report layout.

  • Column field— Column field labels have a column orientation in a pivot table report and are displayed as column labels. Appears in the COLUMN area of a pivot table report layout.

  • Data field— Data fields from a list or table contain summary data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required