Facebook pixel Pivot Table Terminology | Pepperdine University | Pepperdine Community

Pivot Table Terminology

  • Column field: A field that has a column orientation in the pivot table. Each item in the field occupies a column. Column fields can be nested.
  • Data Areas: The cells in a pivot table that contain the summary data. Excel offers several ways to summarize the data (sum, average, count, and so on).
  • Grand totals: A row or column that displays totals for all cells in a row or column in a pivot table. You can specify that grand totals be calculated for rows, columns, or both (or neither).
  • Group: A collection of items that are treated as a singe item. You can group items manually or automatically (group dates into months, for example).
  • Item: An element in a field that appears as a row or column header in a pivot table.
  • Page field: A field that has a page orientation in the pivot table -- similar to a slice of a three-dimensional cube. Only one item in a page field can be displayed at one time.
  • Refresh: To recalculate the pivot table after changes to the source data have been made.
  • Row field: A field that has a row orientation in the pivot table. Each item in the field occupies a row. Row fields can be nested.
  • Source data: The data used to create a pivot table. It can reside in a worksheet or an external database.
  • Subtotals: A row or column that displays subtotals for detail cells in a row or column in a pivot table.