Pinterest Pixel

Group Two Excel Pivot Tables Independently

Bryan
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 workbookGroup-two-pivot-tables-independently.xlsx


Here is our Pivot Table setup:

Group Two Excel Pivot Tables Independently

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

Pick any cell right next to it and select Paste.

Group Two Excel Pivot Tables Independently

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

Group Two Excel Pivot Tables Independently

Make any grouping selection that you prefer and click OK

Group Two Excel Pivot Tables Independently

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

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

Group Two Excel Pivot Tables Independently

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

Group Two Excel Pivot Tables Independently

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

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

Group Two Excel Pivot Tables Independently

STEP 8: Paste this back on the original workbook

Group Two Excel Pivot Tables Independently

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

Group Two Excel Pivot Tables Independently

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

 

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

If you like this Excel tip, please share it



Group Two Excel Pivot Tables Independently | MyExcelOnline


Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Show The Percent of Column Total With Excel Pivot Tables

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...