In a comment on this blog, someone asked how to create two pivot tables on the same Excel worksheet.
NOTE: See the updated version of this Two Pivot Tables article, from July 2020.
Shown below is a worksheet named Pivot_Reports, with a pivot table on it, based on the data on the Sales_East sheet.
We’ll add another pivot table to the Pivot_Reports sheet, based on data on the Sales_North sheet.
Add the Second Pivot Table
- Select the Sales_North sheet, and select a cell in the data table.
- On the Ribbon, click the Insert tab
- In the Tables group, click PivotTable (click the top half of the PivotTable command).
- In the Create PivotTable dialog box, at the top, leave the default selection of Select a Table or Range, where the Sales_North table shows.
- In the lower section, click Existing Worksheet.
- Click in the Location box, then click on the sheet tab for the Pivot_Reports sheet.
- Click on the cell where the second pivot table should start.
- Click OK to create the new pivot table.
- Add the fields that you’d like in the new pivot table.
The second pivot table is added to the Pivot_Reports worksheet.
Prevent Pivot Table Overlap
When you have two or more pivot tables on the same worksheet, be careful to prevent them from overlapping.
Before you add new fields to the pivot table on the left, you might have to add blank columns between the pivot tables. Or, if one pivot table is above the other, add blank rows between them.
If the pivot tables will change frequently, adding and removing fields, it may be better to keep the pivot tables on separate sheet.
This short video shows pivot table refresh problems, and how to avoid them. For detailed written notes, go to the Pivot Table Errors page on my Contextures site.
Related Articles
Create Two Pivot Tables On Excel Worksheet
____________