How to Use Pivot Tables in Looker Dashboards

Transforming rows of raw data into a clear, insightful summary can feel like a daunting task, but Looker's pivot tables are designed to do exactly that. By turning a flat list of information into a dynamic grid, pivot tables allow you to cross-reference different categories and uncover patterns that would otherwise stay hidden. This guide will walk you through exactly how to create, customize, and effectively use pivot tables in your Looker dashboards.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly Is a Pivot Table and Why Use One?

A pivot table is a data summarization tool that reorganizes information from a standard table into a new one where rows and columns are used to represent different points of data. Imagine you have a spreadsheet with hundreds of rows, and each row details a single sale with columns for Product Category, Sales Region, Sale Date, and Revenue. This format is great for storing data but terrible for understanding it at a glance.

A pivot table takes that data and "pivots" one of the columns (like Sales Region) from being just another column into the actual headers for new columns in your table. The result might be a grid showing each Product Category as a row and each Sales Region as a column, with the total Revenue at the intersection of each.

Here’s why pivot tables are so valuable in Looker:

• Summarize Vast Datasets: They condense thousands or even millions of rows into a compact and digestible format, making it easy to see the big picture.
• Reveal Hidden Patterns: Quickly spot key relationships. Which product sells best in the Northeast? Was there a spike in accessory sales in California last quarter? Pivot tables make these insights jump out.
• Dynamic and Flexible Analysis: You aren't locked into one view. In Looker’s Explore environment, you can quickly change which fields are rows, columns, or values, allowing you to slice and dice your data from different angles in seconds.
• Cross-Tabulation: They are perfect for analyzing the relationship between two categorical variables (like "traffic source" vs. "user country") and seeing how a numerical value (like "conversion rate") is distributed across them.

A Step-by-Step Guide to Building a Pivot Table in Looker

All pivot tables begin life in a Looker Explore, which is the user-friendly interface for building queries and visualizing data without writing any code. Let's build one together from scratch.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Choose Your Dimensions and Measures

First, navigate to the Explore where your desired data lives (e.g., an Order Data, Website Traffic, or Sales Explore). Here, you need to select the components of your table. Remember these key distinctions:

• Dimensions: These are the descriptive, categorical attributes of your data. Think of them as the "who, what, where, and when." Examples include Product Name, User's Country, Traffic Source, or Order Status.
• Measures: These are the quantitative, numerical values you want to calculate or aggregate. They are the "how much" or "how many." Examples are Total Revenue, Count of Users, Average Order Value, or Max Session Duration.

For a pivot table, you must select at least two dimensions and one measure. For our example, let's say we want to analyze e-commerce orders. We'll select:

• Dimension 1: Product Category
• Dimension 2: User's State
• Measure 1: Order Count

At this stage, you're just picking the raw ingredients. Don't worry about the layout yet.

Step 2: Run the Initial Query

Once you've selected your fields, click the Run button. Looker will fetch the data and present it as a standard flat table. You'll see three columns: Product Category, User's State, and Order Count. It’s useful, but it’s still just a long list and hard to compare states side by side.

Now for the key move. We need to decide which dimension we want to "pivot" to become the new column headers. Our goal is to see a breakdown of order count by category, spread across different states. Therefore, we should pivot the User's State dimension.

To do this, find the User's State dimension in the data results pane. Hover over its column header and click the gear icon that appears. From the dropdown menu, select Pivot.

Your data table will be completely transformed. The Product Category dimension remains the row headers down the left side. But now, the unique values from the User's State dimension (California, New York, Texas, etc.) have become the column headers across the top. The cells in the table display the Order Count corresponding to each product category and state combination. You have just created a pivot table!

Customizing Your Pivot Table for Maximum Impact

A basic pivot table is great, but Looker offers a ton of customization options to make your data even more insightful and ready for a dashboard.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Totals

One of the most useful features of pivot tables is the ability to see totals automatically. In the Data section, check the box for Totals. When you rerun the query, Looker will add:

• Row Totals: A column on the right showing the total for each row (e.g., total orders for the "T-Shirts" category across all states).
• Column Totals: A row at the bottom showing the total for each column (e.g., total orders from all product categories in "California").

This simple checkbox provides an immediate layer of valuable context to your summary.

Hiding and Moving Columns

If you pivot a dimension with many unique values, your table can become very wide. To simplify the view, you can hide columns you're not interested in. Hover over a column header, click the gear icon, and select Hide column. You can also reorder columns by simply dragging and dropping them in the results pane to get the perfect arrangement before you save it to a dashboard.

Cell Visualization

This is where your table can really come to life. In the Visualization tab, select the Table chart type. Now navigate to the Edit menu to open the visualization options pane. A powerful setting here is Cell Visualization.

By enabling this, you turn your boring table of numbers into a heatmap. Looker will automatically color the background of each cell based on its value - for instance, high numbers get a dark green and low numbers get a light green. This technique makes spotting outliers, trends, and top performers nearly effortless. Your eyes are immediately drawn to the most important cells without you having to read every single number.

Value Formatting

Use the formatting options to make your numbers cleaner. In the Edit menu for the visualization, you can edit how the values for each field are displayed. For revenue fields, you can set the format to Currency. For metrics like conversion rates, you can display them as percentages with a set number of decimal points. Clean formatting makes your tables far more professional and easy to read.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Adding Your Pivot Table to a Looker Dashboard

Once your pivot table looks exactly how you want it, it's time to add it to a dashboard for easy access and monitoring.

1. Click the gear icon in the top right corner of the Explore.
2. Select Save from the dropdown menu.
3. You'll get an option to save your creation as a "Look" (a single saved visualization) or to add it to a dashboard.
4. Choose Save to a Dashboard, then select an existing dashboard or create a new one.

On a dashboard, your pivot table becomes an interactive tile. It will respond to any dashboard-level filters (like a date range chooser) and will automatically refresh with the latest data. Team members can view, interact with, and even download the data from your table directly from the dashboard, making it a shareable source of truth.

Pro Tips for Looker Pivots

• Be Mindful of Cardinality: Avoid pivoting dimensions with extremely high cardinality (a large number of unique values), like UserID, Timestamp, or Product SKU. This will create a table with hundreds or thousands of columns, making it unreadable and slow. Stick to categorical dimensions with fewer unique entries like Month, Country, or Department.
• Understanding Nulls (Empty values): If you see a blank cell, it means there is no data for that specific row/column intersection. For example, a blank cell at the intersection of "Sweaters" and "Florida" likely means no sweaters were sold in Florida. It's not an error - it's an insight!
• You Can Only Pivot Dimensions: It’s a common mix-up for beginners, but remember that you can only pivot an attribute or category (a dimension). Measures are the values that populate the grid, they can’t form the structure of the grid itself.

Final Thoughts

Crafting a pivot table in Looker is a fantastic way to transform lists of data into an organized, insightful summary that highlights key business trends. By carefully selecting dimensions and measures, pivoting the right field, and using visualization tweaks like totals and heatmaps, you can build powerful and interactive reports for your dashboards.

Of course, even powerful tools like Looker require a manual process of selecting fields, running queries, making adjustments, and learning the terminology. At Graphed, we focus on making that process instant. We believe you shouldn't have to think like a data analyst to get an answer - just ask a question in plain English. Instead of building a pivot table step by step, you could ask, "Show me a breakdown of order count by product category for each state in a table," and our AI data analyst builds the report for you with live data. If you're looking for a faster way to get answers from all your business data, you might enjoy using Graphed.