Pivot table extension
  • 05 Jul 2022
  • 3 Minutes to read
  • Dark
    Light

Pivot table extension

  • Dark
    Light

A pivot table is a versatile tool that helps you summarize the information in a table by slicing and dicing it so you can look at it from different perspectives. It works by grouping records together based on either one or two fields, and summarizing the data from those records, either by counting the number of records per group, or by using a specific summary function (like sum, average, or maximum) on another field.

NOTE

Extensions let you extend the functionality of your bases: you can use extensions to bring new information into Airtable, visualize and summarize your records in colorful ways, and even directly integrate your Airtable bases with your favorite extensions.

Why use a pivot table?

A pivot table is a versatile tool that can be used to summarize the information in a table in new and useful ways by creating another table. It's useful for when you have lots of numbers that need summarizing, when you want to compare subsets of data, or when you’re trying to find trends in your data.

pivotgif

Note that we do not currently support exporting or printing pivot tables at this time. We recommend taking a screenshot on the extension if you'd like to share it externally.

Setting up a pivot table

To get started, first install the pivot table extension. Once installed, the extension will open up to fill your screen. By default, the extension will automatically select the most recent table and view in which you were working, but you can change the target table and view as desired.

Row grouping allows you to select the field which will define the rows of your pivot table, whereas column grouping allows you to select the field which will define the columns of your pivot table.

Note that while a row grouping is required to build a pivot table, a column grouping is not required. If you select None as the column grouping option, then there will be no column grouping, and the summary function will just apply to the row groups. (This looks somewhat similar to using grouped records and the summary bar to create reports.)

Screen Shot 2017-10-19 at 2.49.29 PM

When picking your row and column groupings, if you have a field where each cell can contain multiple choices (such as a collaborator field allowing multiple collaborators, a linked record field allowing linking to multiple records, or a multiple select field), you will have the option to split multiple choices.

Splitting multiple choices in a row or column grouping means that a record containing multiple choices in the specified field will be counted/summarized separately for each choice. For example, a record containing options “A” and “B” will be counted under both “A” and “B.” In contrast, not splitting the choices means that the pivot table will treat separate compositions of multiple choices as different choices in themselves; a record containing options “A” and “B” will not be counted under “A” or “B,” but rather, under “A, B”.

split multiple choices

Once you’ve picked row and/or column groupings, you can choose to summarize the data by Count or by a Specific field. Count simply displays the number of records that are included in the row (and column) grouping(s).

1-vil7Y6BrSAClb6ve4XrHgQ

Specific field displays the results of a summary function performed on a specific field. If you pick specific field, you'll need to select the specific field, and a type of summary function, like sum, average, or maximum. The available summary functions will depend on the field type.

1-3tmfvyYu-mxUQDHN2soDbg

Sorting order

Both rows and columns can be sorted within the pivot table extension using one of the following:

  • Group: The values in the field that make up the headings of the rows and columns (numerical order for number types, alphabetical order for text, order of select options for single select / split multi select)
  • Value: Row/column summary values (ie count, aggregate values, etc)

pivot-table-sort-rows


Was this article helpful?