Excel 2007 : How to group data in pivot table without impactng other tables using same source data

Hello Amit,

you will need to create a separate Pivot Cache for each pivot table where you want separate grouping applied.

In Excel 2003 it was relatively simple to use the Pivot Table Wizard to do that, but in Excel 2007 and later, the Pivot Table Wizard is no longer in the menu. But you can still use the keyboard shortcut to start the wizard and create a pivot table with its own pivot cache.

1. hold down the Alt key and press D then P. This starts the Pivot table wizard.
2. select Excel List or Database and click Next
3. Select the data source for the pivot table and click Next.
4. Now Excel will come up with a message box. If you click Yes, it will use the same pivot cache as you have already set up for the first pivot table. This will save memory, but you will not be able to create separate groupings for separate pivot tables.
5. Click No, so Excel will create a separate pivot cache for the new pivot table.
6. Go through the rest of the wizard and then set up your new pivot table.

You can now change the grouping in the new pivot table, and the previously created pivot table(s) will not be affected.

hope that helps

cheers