Group Two Excel Pivot Tables Independently | MyExcelOnline

When you duplicate a pivot table, there is one quirk if you need to set up the grouping. The same grouping will somehow apply to both pivot tables.

Let me demonstrate how you can group two pivot tables independently.

Exercise Workbook:

DOWNLOAD EXCEL WORKBOOK


Here is our Pivot Table setup:

Group Two Excel Pivot Tables Independently | MyExcelOnline

STEP 1: Let us duplicate this, select the entire Pivot Table by pressing CTRL + A, right-click and select Copy

Group Two Excel Pivot Tables Independently | MyExcelOnline

Pick any cell right next to it and select Paste.

Group Two Excel Pivot Tables Independently | MyExcelOnline

STEP 2: Right-click on the new Pivot Table and select Group

Group Two Excel Pivot Tables Independently | MyExcelOnline

Make any grouping selection that you prefer and click OK

Group Two Excel Pivot Tables Independently | MyExcelOnline

STEP 3: Notice that the grouping is applied to both Pivot Tables! But we do not want that to happen.

Click the Undo button and let us work on the workaround for this.

Group Two Excel Pivot Tables Independently | MyExcelOnline

STEP 4: Select the new Pivot Table and click the Cut icon

Group Two Excel Pivot Tables Independently | MyExcelOnline

STEP 5: Open a new Excel workbook by pressing CTRL + N and select Paste

Group Two Excel Pivot Tables Independently | MyExcelOnline

STEP 6: Now right-click on this Pivot Table in the new Excel workbook, select Group and pick the groupings that you prefer. Click OK

Group Two Excel Pivot Tables Independently | MyExcelOnline

STEP 7: Looking good! Select this Pivot Table and click the Cut icon again

Group Two Excel Pivot Tables Independently | MyExcelOnline

STEP 8: Paste this back on the original workbook

Group Two Excel Pivot Tables Independently | MyExcelOnline

You will notice that the grouping is now applied only to this Pivot Table!

group two pivot tables

This is how you can easily group two Pivot Tables independently!

 

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Share on LinkedIn