Microsoft Office Tutorials and References
In Depth Information
• Column labels: A field that has a column orientation in the pivot table. Each item in the field occupies a column.
In the figure, Customer represents a column field that contains two items (Existing and New). You can have nes-
ted column fields.
• Grand total: 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). The pivot table in the figure shows grand
totals for both rows and columns.
• Group: A collection of items treated as a single item. You can group items manually or automatically (group
dates into months, for example). The pivot table in the figure does not have any defined groups.
• Item: An element in a field that appears as a row or column header in a pivot table. In the figure, Existing and
New are items for the Customer field. The Branch field has three items: Central, North County, and Westside.
AcctType has four items: CD, Checking, IRA, and Savings.
• Refresh: Recalculates the pivot table after making changes to the source data.
• Row labels: A field that has a row orientation in the pivot table. Each item in the field occupies a row. You can
have nested row fields. In the figure, Branch and AcctType both represent row fields.
• Source data: The data used to create a pivot table. It can reside in a worksheet or an external database.