Add Another Pivot Table: Extend your Excel Analysis

Lauren Aug 08, 2026

Ever wished to analyze your data from two different perspectives simultaneously in Excel? Adding a second pivot table to your worksheet can make this possible. In this guide, we'll delve into the process, breaking it down into manageable steps.

39K views | Reel by Miss Excel
39K views | Reel by Miss Excel

Before we dive in, ensure you have Excel 2013 or later, as the steps might vary for older versions.

50 Things You Can Do With Excel Pivot Table | MyExcelOnline
50 Things You Can Do With Excel Pivot Table | MyExcelOnline

Understanding Pivot Tables

A pivot table is a powerful tool that summarizes, analyzes, explores, and presents large amounts of data. By rearranging existing data, it enables you to see new perspectives and make informed decisions.

How to Create a Pivot Table using Multiple Files in Excel
How to Create a Pivot Table using Multiple Files in Excel

When you add a second pivot table, you can compare data from two different perspectives. For instance, you could analyze sales data by both region and product category in separate tables.

Preparing Your Data

How to Use Calculated Fields in Pivot Tables in Google Sheets
How to Use Calculated Fields in Pivot Tables in Google Sheets

Before creating your pivot tables, ensure your data is clean and structured correctly. Remove duplicates, fill in missing values, and ensure no stray commas or leading zeros are affecting your data.

Also, make sure your data is suitable for analysis. A pivot table works best with tabulated data, typically with rows representing different categories and columns representing measures or details.

Creating the First Pivot Table

the pivottable field list dialog box is shown in this screenshote
the pivottable field list dialog box is shown in this screenshote

Let's assume you have a dataset with 'Sales', 'Region', 'Product Category', and 'Date'. After selecting this data, navigate to 'Insert' in the ribbon, then 'PivotTable'. Choose where you want to place the pivot table, then select 'OK'.

In the 'PivotTable Fields' pane, drag 'Sales' under 'Values' and 'Region' and 'Product Category' under 'Rows'. In the 'uko premium_data' sheet, click 'OK'. Your first pivot table is ready. Now, let's add a second one.

Adding a Second Pivot Table

How to Create Pivot Table in Excel With Step by Step Guide
How to Create Pivot Table in Excel With Step by Step Guide

To add a second pivot table, move your cursor to the cell at the bottom right of your existing pivot table. You'll see a small icon appear. Click it, then select 'Insert PivotTable' from the dropdown.

Choose the range for your new pivot table, ensuring it doesn't overlap with the first. Select 'OK'. Now, let's prepare this table to analyze data from a different perspective.

Master Excel pivot tables in 5 minutes
Master Excel pivot tables in 5 minutes
How to Sort a Pivot Table in Excel (Sorting Pivot Tables)
How to Sort a Pivot Table in Excel (Sorting Pivot Tables)
How to Create Pivot Table in Excel With Step by Step Guide
How to Create Pivot Table in Excel With Step by Step Guide
Customizing Excel Pivot Table Styles | MyExcelOnline
Customizing Excel Pivot Table Styles | MyExcelOnline
How to Remove Grand Total from a Pivot Table in Google Sheets
How to Remove Grand Total from a Pivot Table in Google Sheets
How to Create a Pivot Table in Google Sheets
How to Create a Pivot Table in Google Sheets
How to Move a Pivot Table in Excel
How to Move a Pivot Table in Excel
How to Create Pivot Table in Excel With Step by Step Guide
How to Create Pivot Table in Excel With Step by Step Guide
50 Things You Can Do With Excel Pivot Table | Free Microsoft Excel Tutorials
50 Things You Can Do With Excel Pivot Table | Free Microsoft Excel Tutorials
Count Unique Values in a Pivot Table
Count Unique Values in a Pivot Table
Master Google Sheets: The Only Ultimate Guide You’ll Ever Need (2025)
Master Google Sheets: The Only Ultimate Guide You’ll Ever Need (2025)
Using Pivot Tables to Analyze Income and Expenses
Using Pivot Tables to Analyze Income and Expenses
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
What is the use of Pivot Table and Pivot Chart in Excel
What is the use of Pivot Table and Pivot Chart in Excel
How to Use Pivot Tables in 4 Easy Steps | The Finance posted on the topic | LinkedIn
How to Use Pivot Tables in 4 Easy Steps | The Finance posted on the topic | LinkedIn
Advanced Excel - Creating Pivot Tables in Excel
Advanced Excel - Creating Pivot Tables in Excel
Automate Pivot Table with Python (Create, Filter and Extract) | Towards Data Science
Automate Pivot Table with Python (Create, Filter and Extract) | Towards Data Science
The Simple Guide to Using Pivot Tables to Understand Marketing Data
The Simple Guide to Using Pivot Tables to Understand Marketing Data
Sample of Pivot Table  using google Sheet
Sample of Pivot Table using google Sheet
How to Delete or Remove a Pivot Table in Excel
How to Delete or Remove a Pivot Table in Excel

Setting Up the Second Pivot Table

Say you want to analyze sales data by 'Date' and 'Product Category'. In the 'KO_uko premium_data' sheet, go to the 'PivotTable Fields' pane. Here, drag 'Sales' under 'Values', 'Date' under 'Rows', and 'Product Category' under 'Columns'.

Voila! You now have two pivot tables in your worksheet, offering different views of the same data.

Comparing and Analyzing

Pivot tables allow you to compare and analyze data in meaningful ways. With two pivot tables, you can compare trends over time, contrast sales by region and by product category, or even identify which products sell best in which regions.

Additionally, you can format your pivot tables for better readability. Use conditional formatting, change text colors, or highlight important data to draw attention to key insights.

In Excel, there's always more to discover. Experiment with different data views, explore more features of pivot tables, and make your data work for you. Happy pivoting!