Excel Pivot Table Terminology

You have to understand the terminology associated with pivot tables. It is the first step to the master Excel pivot table. See the following Figure.

Pivot Table Terminology

A pivot table

Column labels

Each item in the field occupies a column. In our above figure, Customer represents a column field and Customer contains two items (Existing and New). There may have nested column fields.

Read More: How to Insert a Calculated Item into Excel Pivot Table!

Grand totals

A row or column that displays totals for all cells in a row or column in a pivot table. Grand totals can be calculated for rows, columns, or both (or neither). The pivot table shown in the above figure shows the grand totals for both rows and columns.

Group

A group is a collection of items treated as a single item. The pivot table shown in our figure does not have any defined groups.

Item

Item is a field that appears as a row or column header in a pivot table. In our above 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

Refresh recalculates the pivot table after you have made some changes to the source data.

Row labels

Each item in the field occupies a row. Nested row fields are also possible. In the above figure, Branch and AcctType both represent row fields.

Source data

Source data is the data that is used to create a pivot table. Source data can in a worksheet or an external database.

Subtotals

The pivot table shown in the figure displays subtotals for each branch, below the data. You can also display subtotals above the data or hide subtotals.

Table Filter

Using a table filter, you can choose one item, multiple items, or all items in a page field at one time. In the figure, OpenedBy represents a table filter that displays All items. Click on it, and you can choose different options to choose from.

Read More: How to Create an Average Calculated Field in Excel Pivot Table

Values area

Values areas are the cells in a pivot table that contain the summary data. Excel offers many ways to summarize the data (sum, average, count, and so on).

Right-click on any value in the pivot table and then use the following figure to change the option.

Some Pivot Table examples

Right-click on any value in the pivot table and choose commands Summarize Values By ⇒ Count

Download Sample File

Bank-accounts.xlsx

Happy Excelling 🙂


Hello! Welcome to my Excel blog! I am conducting deep dives into the world of Excel. Please join with me and explore Excel deeply. Keep in mind this African proverb: "If you want to go fast, go alone, If you want to go far, go together." Let's together explore Excel deeply! ☕

5 Comments
  1. Reply
    shivaji upase August 18, 2015 at 10:06 PM

    Really, The website from which you interpreting things about excel is excellent !!
    Thanks Buddy for your contribution on this.

    • Reply
      Kawser August 19, 2015 at 12:27 AM

      Shivaji,
      It is my achievement when a person says me that I helped him/her in some way. Thanks. Keep in touch.

  2. Reply
    shivaji upase August 18, 2015 at 10:08 PM

    Could you please send me the resources for Excel VBA and ACCESS VBA Including books

    • Reply
      Kawser August 19, 2015 at 12:31 AM

      Shivaji,
      Right now I have no book on Microsoft Access. But just subscribe my Email list using the below link, you will get two books on Excel: 1200+ Macro Examples E-Book, 220+ Excel Keyboard Shortcuts E-Book and other Excel resources.
      http://www.eepurl.com/bqFItv

    Leave a reply