Search this site
Embedded Files
  • Home
  • Data Studio
    • What Is GLDS
    • Why Use GLDS
    • Data Connectors
    • Customized Dashboard
  • Services
    • Building
    • Maintenance
    • Training
    • What Do I Need?
  • Team
  • Contact
  • Guides
    • Most Used Features
    • Configuration Guide
      • Background and Border in Google Data Studio
      • Missing Data in Google Data Studio
      • Conditional Formatting in Google Data Studio
      • Chart Header in Google Data Studio
      • Legends in Google Data Studio
      • Reference Lines in Google Data Studio
      • Report Settings
      • Data Blending in Google Data Studio
      • Share Report
      • Manual Publishing
      • Version History
      • Embed a report
      • Get a link to your report
      • Schedule Email Delivery
      • Download as a PDF
      • Interface, Menu and Features
      • Most Used Terms
      • Keyboard Shortcuts
      • Theme and Layout
      • 10 Reasons You Should Be Using Google Data Studio
      • FAQs
    • Charts Guide
      • Scorecard in Google Data Studio
      • Pie Chart in Google Data Studio
      • Bullet Chart in Google Data Studio
      • Gauge Chart in Google Data Studio
      • Line Chart in Google Data Studio
      • Column Charts in Google Data Studio
      • Combo Chart in Google Data Studio
      • Table Chart in Google Data Studio
      • Pivot Table in Google Data Studio
      • Area Chart in Google Data Studio
      • Scatter Chart in Google Data Studio
      • Bubble Chart in Google Data Studio
      • Maps in Google Data Studio
      • Treemaps in Google Data Studio
      • Bullet Chart vs Gauge Chart in Google Data Studio
    • Google Analytics 4 Dimensions and Metrics Definition
    • FAQ
 
  • Home
  • Data Studio
    • What Is GLDS
    • Why Use GLDS
    • Data Connectors
    • Customized Dashboard
  • Services
    • Building
    • Maintenance
    • Training
    • What Do I Need?
  • Team
  • Contact
  • Guides
    • Most Used Features
    • Configuration Guide
      • Background and Border in Google Data Studio
      • Missing Data in Google Data Studio
      • Conditional Formatting in Google Data Studio
      • Chart Header in Google Data Studio
      • Legends in Google Data Studio
      • Reference Lines in Google Data Studio
      • Report Settings
      • Data Blending in Google Data Studio
      • Share Report
      • Manual Publishing
      • Version History
      • Embed a report
      • Get a link to your report
      • Schedule Email Delivery
      • Download as a PDF
      • Interface, Menu and Features
      • Most Used Terms
      • Keyboard Shortcuts
      • Theme and Layout
      • 10 Reasons You Should Be Using Google Data Studio
      • FAQs
    • Charts Guide
      • Scorecard in Google Data Studio
      • Pie Chart in Google Data Studio
      • Bullet Chart in Google Data Studio
      • Gauge Chart in Google Data Studio
      • Line Chart in Google Data Studio
      • Column Charts in Google Data Studio
      • Combo Chart in Google Data Studio
      • Table Chart in Google Data Studio
      • Pivot Table in Google Data Studio
      • Area Chart in Google Data Studio
      • Scatter Chart in Google Data Studio
      • Bubble Chart in Google Data Studio
      • Maps in Google Data Studio
      • Treemaps in Google Data Studio
      • Bullet Chart vs Gauge Chart in Google Data Studio
    • Google Analytics 4 Dimensions and Metrics Definition
    • FAQ
  • More
    • Home
    • Data Studio
      • What Is GLDS
      • Why Use GLDS
      • Data Connectors
      • Customized Dashboard
    • Services
      • Building
      • Maintenance
      • Training
      • What Do I Need?
    • Team
    • Contact
    • Guides
      • Most Used Features
      • Configuration Guide
        • Background and Border in Google Data Studio
        • Missing Data in Google Data Studio
        • Conditional Formatting in Google Data Studio
        • Chart Header in Google Data Studio
        • Legends in Google Data Studio
        • Reference Lines in Google Data Studio
        • Report Settings
        • Data Blending in Google Data Studio
        • Share Report
        • Manual Publishing
        • Version History
        • Embed a report
        • Get a link to your report
        • Schedule Email Delivery
        • Download as a PDF
        • Interface, Menu and Features
        • Most Used Terms
        • Keyboard Shortcuts
        • Theme and Layout
        • 10 Reasons You Should Be Using Google Data Studio
        • FAQs
      • Charts Guide
        • Scorecard in Google Data Studio
        • Pie Chart in Google Data Studio
        • Bullet Chart in Google Data Studio
        • Gauge Chart in Google Data Studio
        • Line Chart in Google Data Studio
        • Column Charts in Google Data Studio
        • Combo Chart in Google Data Studio
        • Table Chart in Google Data Studio
        • Pivot Table in Google Data Studio
        • Area Chart in Google Data Studio
        • Scatter Chart in Google Data Studio
        • Bubble Chart in Google Data Studio
        • Maps in Google Data Studio
        • Treemaps in Google Data Studio
        • Bullet Chart vs Gauge Chart in Google Data Studio
      • Google Analytics 4 Dimensions and Metrics Definition
      • FAQ
Looker Studio > Charts Guide > Pivot Tables

A Pivot Table stores the summary of a specific data set in a condensed manner or groups data together in a meaningful way. My personal favorite is to treat Pivot Tables as raw data export tables into Excel and Google Sheets for detailed analysis.

1. Pivot Table

Pivot Table in Google Data Studio
Pivot Table in Looker Studio (Formerly known as Data Studio)
  • In this chart, we are displaying Users by Age Group and Users Type for the selected time range.

Recommended: Yes [Table A]

  • Both Pivot Tables and Tables can handle large data sets and in most cases, these two types of charts are the most suitable choice for displaying an extensive data set.

2. Pivot Table With Bars

Pivot Table with bars in Google Data Studio
Pivot Table with bars in Looker Studio (Formerly known as Data Studio)
  • In this chart, we are displaying Users by Age Group and Users Type for the selected time range.

Recommended: Yes [Table A]

  • Both Pivot Tables and Tables can handle large data sets and in most cases, these two types of charts are the most suitable choice for displaying an extensive data set.

3. Pivot Table With Heatmap

Pivot Table with heatmap in Google Data Studio
Pivot Table with heatmap in Looker Studio (Formerly known as Data Studio)
  • In this chart, we are displaying Users by Age Group and Users Type for the selected time range.

Recommended: Yes [Table A]

  • Both Pivot Tables and Tables can handle large data sets and in most cases, these two types of charts are the most suitable choice for displaying an extensive data set.

4. Pivot Table With Bars: with "Expand — collapse" option

Pivot Table With Bars: with "Expand — collapse" option
Pivot Table With Bars: with "Expand — collapse" option in Looker Studio (Formerly known as Data Studio)
  • "Default expands level." Is fixed and not possible to deselect (country in the below example). Secondary expand level can be selected or deselect (Continent and Sub-Continent in the above example)

Recommended: No

  • Hard to digest the data and structure for most of the users. Please avoid "Expand —collapse" in a Pivot Table

  • [Expand — collapse] — it's recommended that this is avoided — even after working in the Data Analytics field for over eight years, I still find this confusing! However, if you do choose to use it, this operates similarly to Optional Dimensions for other charts, though there is no way to deselect the default dimension. An example is shown below.

Charts Guide:
  • Scorecards
  • Pie/Doughnut Chart
  • Bullet Charts
  • Gauge Charts
  • Line Charts/Time Series Charts
  • Column Charts
  • Combo Charts
  • Table
  • Pivot Tables
  • Area Charts
  • Scatter Charts
  • Bubble Chart
  • Geo Maps Charts
  • Treemap
  • Bullet Chart vs Gauge Chart

Configuration across chart:
  • Background and Border
  • Missing Data
  • Conditional Formatting
  • Chart Header
  • Legends
  • Reference Lines
  • Report Settings

Most Used Features:
  • Report Sharing
  • Manual Publishing
  • Version History
  • Embed a Report
  • Get a link to your report
  • Schedule Email Delivery
  • Download as PDF
  • Interface Menu & Features
  • Most Used Terms
  • Keyboard Shortcuts
  • Theme and Layout
COMPANY
3Pie AnalyticsFrankfurt am Main, GermanyTel.: +49 176 226798 26E-Mail: hello@3pieanalytics.comLink: www.3pieanalytics.comLinkedin: https://www.linkedin.com/company/3pie-analytics/ImpressumSustainability
SITE LINKSHomeGoogle Data StudioServicesTeamContactGuides
Copyright 2022 - 3Pie Analytics - All Rights Reserved
Google Sites
Report abuse
Google Sites
Report abuse