Boost Productivity: Adding a Second Pivot Table

Lauren Aug 08, 2026

Expanding your data analysis capabilities in Excel often involves adding more pivot tables. A second pivot table can provide additional insights, or allow you to slice your data in different ways. Here's a step-by-step guide on how to add a second pivot table, optimally laid out for both SEO and user experience.

Ultimate excel pivot tables tutorial
Ultimate excel pivot tables tutorial

Before we delve into the process, ensure your data is well-structured and cleaned to avoid any inconsistencies that could affect the accuracy of your pivot tables.

50 creative things to do with excel pivot tables
50 creative things to do with excel pivot tables

Understanding the Basics of a Second Pivot Table

A second pivot table, like the first, serves as a dynamic summary of your data. It allows you to interactively analyze your data by varying the data categories and summary methods.

428 reactions · 99 shares | My Learning Sheet on Reels
428 reactions · 99 shares | My Learning Sheet on Reels

Let's start by understanding why you might need a second pivot table. You may want to compare different datasets, use different data fields, or analyze your data from a different perspective.

When to Use a Second Pivot Table

How to Update an Excel Pivot Table - Even if the Source Data Changes (+ video tutorial)
How to Update an Excel Pivot Table - Even if the Source Data Changes (+ video tutorial)

In many cases, a second pivot table is useful when you want to analyze a different aspect of your data that the first pivot table doesn't cover. For instance, while your first pivot table might compare sales by region, a second one could compare sales by product category or salesperson.

Additionally, pivot tables can interact with each other. Each pivot table can display values from multiple fields, so they can be used in combination to provide a more comprehensive analysis.

Impact of a Second Pivot Table on Workbook Performance

Excel Pivot Table Explained (Part 1) | Easy Guide for Beginners with Example
Excel Pivot Table Explained (Part 1) | Easy Guide for Beginners with Example

Adding a second pivot table can slightly impact the performance of your Excel workbook, especially with large datasets. Therefore, it's essential to consider this when deciding to add another pivot table.

To mitigate potential performance issues, ensure your source data is regularly cleaned, and any fields not needed in the pivot tables are removed. You can also minimize the impact by using a structured reference instead of a cell reference for the source data field.

Steps to Add a Second Pivot Table

the pivot tables basics poster is shown in green and white, with text on it
the pivot tables basics poster is shown in green and white, with text on it

Adding a second pivot table involves selecting your data, choosing where you want the pivot table, and designing it to suit your needs.

Here are the key steps:

101 Time-Saving Pivot Table Tricks For Smarter Reports
101 Time-Saving Pivot Table Tricks For Smarter Reports
Management training, Soft skills, Power BI, Excel Learning solutions
Management training, Soft skills, Power BI, Excel Learning solutions
Advanced Pivot Table Techniques (to achieve more in Excel)
Advanced Pivot Table Techniques (to achieve more in Excel)
Pivot Table Basics For Search Marketers
Pivot Table Basics For Search Marketers
How to Sort a Pivot Table in Excel (Sorting Pivot Tables)
How to Sort a Pivot Table in Excel (Sorting Pivot Tables)
Master Pivot Tables - 101 Excel Examples
Master Pivot Tables - 101 Excel Examples
How to create a new pivot table style
How to create a new pivot table style
Using Pivot Tables to Analyze Income and Expenses
Using Pivot Tables to Analyze Income and Expenses
How to Create a Pivot Table using Multiple Files in Excel
How to Create a Pivot Table using Multiple Files in Excel
the pivot tables explain how to use it in an interactive game, and what they are
the pivot tables explain how to use it in an interactive game, and what they are
Excel Pivot Tables Unleashed - 50 Techniques You Should Know
Excel Pivot Tables Unleashed - 50 Techniques You Should Know
Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one
Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one
Excel Formulas Unleashed
Excel Formulas Unleashed
How to create a pivot table in Excel to slice and dice your data
How to create a pivot table in Excel to slice and dice your data
How to Make a Pivot Table Timeline in Excel - Tutorial
How to Make a Pivot Table Timeline in Excel - Tutorial
How to Delete or Remove a Pivot Table in Excel
How to Delete or Remove a Pivot Table in Excel
How to Add a Calculated Field to an Excel Pivot Table - Excel Tutorial
How to Add a Calculated Field to an Excel Pivot Table - Excel Tutorial
Count Unique Values in a Pivot Table
Count Unique Values in a Pivot Table
Show The Percent of Parent Row Total With Excel Pivot Tables | MyExcelOnline
Show The Percent of Parent Row Total With Excel Pivot Tables | MyExcelOnline
Customizing Excel Pivot Table Styles | MyExcelOnline
Customizing Excel Pivot Table Styles | MyExcelOnline
  • Select the data for your second pivot table.
  • Click on "Insert" and choose "PivotTable".
  • Choose where you want the pivot table to go.
  • Drag the data fields into the appropriate areas in the PivotTable Fields pane.
  • Customize your pivot table with filters, sort/filter options, and more.

Every user's data and needs are different, and it's essential to adapt these steps to your specific case.

Comparing and Linking Pivot Tables

One powerful feature of a second pivot table is the ability to compare and link it with the first. You can use the Snapshot feature in Excel to capture the current state of a pivot table and compare it with the state of another pivot table at a later time.

To link pivot tables, you need to ensure that the data sources referenced in both tables are identical. You can then use Conditional Formatting or other Excel features to highlight differences between the tables.

In conclusion, a second pivot table can provide an extra dimension to your data analysis in Excel. It can help you make more informed decisions and gain a deeper understanding of your data's complexities. Regularly review and update your pivot tables to ensure they remain relevant and accurate.