Grouping a field in one pivot tables groups the same field in another table

Solution 1:

By default, Pivot tables share the same pivot cache. If you want two pivot tables with different groupings, you need to make sure that you create two different pivot caches. These will take up more memory, which is why Excel defaults to using one pivot cache.

In Excel 2003 pivot tables were created with the Pivot Table Wizard. This Wizard contains a question in the first step that only appears when you create more than one pivot table. If you keep that option unselected, Excel will create a new pivot cache after issuing a warning.

In Excel 2007 or later, the pivot table wizard is not normally used, so this option is not readily available.

But here's the good news: You can open the Pivot Table Wizard with the keyboard shortcut Alt - D - P. Alternatively, you can add it to a custom group on the ribbon or put it in the QAT. It's in the "Commands not in the ribbon" list.

The keyboard shortcut comes from the Excel 2003 menu bars, Alt - D to open the Data menu, then P to select the Pivot chart wizard: