Google Data Studio Pivot Tables

By Zekeriya Mulbay

This pivot table of grouped values shows the sums, averages, or other statistics of all the individual items in a more extensive table. Pivot tables can be created by using pivot charts to rearrange information.

Pivot tables, take the rows in a standard table and pivot them so they become columns. This lets you group and summarize the data in ways a standard table can't provide.

The following is a standard table listing the Revenue Per User metric by calendar quarter and year:

While this table is useful for showing which country received the most revenue per user and in which quarter, it isn't useful for summarizing this data in a meaningful way.

A pivot table, however, quickly shows the relationship of this data:

This table easily summarizes the data from the previous example. You can also quickly spot outliers or anomalies in your data. Notice that several countries had no revenue in Q4, for example.

Pivot tables in Data Studio support adding multiple row and column dimensions. The example below adds the Gender dimension to the rows. This further breaks down the data, giving you even more insight into your data:

Features

Show totals: Pivot tables support totals and subtotals for both rows and columns:

Expand-collapse: Expand-collapse lets report viewers show or hide different levels of information in the pivot table by clicking + and in the column header. Viewers can then explore the data at the level of detail that interests them most. Expand-collapse also provides a way for a single pivot table to show both summary and detailed information, reducing the number of charts needed in your reports.

How to add a pivot table to your report?

Spread the word

Keep reading