How to Read a Pivot Table

By C.D. Crowder

Pivot tables allow you to create an organized summary of data within a spreadsheet. Pivot tables can calculate data by addition, average, counting and other calculations. A data set is summarized in a chart format which can be updated whenever the data set is updated. A pivot table can include multiple columns and rows from a spreadsheet. Reading a pivot table requires you to understand how data is calculated and the meaning of each heading.

Step 1

Open any spreadsheet or other document containing a pivot table. This tutorial will be based upon an Excel pivot table.

Step 2

Sort and view data by the page field. The page field is located at the top of the pivot table and is separate from the rest of the table. Some pivot tables may not include this field. The page field sorts data by a set of main categories from the data set.

Step 3

View column fields at the top of the pivot table. Row fields are listed along the left side of the pivot table. These two sets of fields are the categories which are summarized or calculated within the body of the pivot table.

Step 4

View data items in the body of the pivot table. Data in the center of the pivot table is the actual summarized or calculated data based upon the row, column and page field headings.

Step 5

View grand totals or summaries in the “Total” or “Grand Total” rows and columns. This is the result of the summarized or calculated data.

Step 6

Sort data by specific headings by clicking the drop-down arrows beside any column or row heading.