This section explains the various elements of a Pivot Table that you need to know.
Pivot Table Elements screen
Row runs horizontally in the Pivot Table.
Row Fields are from the underlying source data that are assigned a row orientation in a pivot table.
Row Header displays the title of a specific row.
Column runs vertically in the Pivot Table.
Column Fields are fields that are assigned a column orientation in a pivot table.
Column Header displays the title of a specific column.
Data Area is a part of a pivot table that contains summary data. The cells of the data area show the summarized data for the items in the row and column fields.
Summary of Data indicates the aggregated sum of a row/column. Each row/column has the aggregated sum at the end of the row/column.
Grand Total is present at the intersection of total rows and total columns. It gives the aggregated sum of all the row/column.