Pivot Table Grouping Issue

[green biro]

Using Excel 2002. I copied and pasted a pivot table to a new sheet, which I
though would create a new pivot table in its own right. However, when I
attempt to group some fields and hide the detail, this action is copied in
the original table so I end up with two grouped tables rather than one
grouped and one ungrouped as wished to have.

Is this normal Excel behaviour and / or is there a workaround?

(Incidentally, I used the copy and paste function rather than create a new
table because I wanted to save some of the settings).

Thanks in advance for any assistance.

 

[Debra Dalgleish]

When you copy a pivot table, both copies use the same pivot cache, and
share any groupings that are created.

To create a second pivot cache:
Right-click a cell in the second pivot table
Click on PivotTable Wizard
Click the Back button
Change the range slightly, to increase it by one row
Click Finish

Right-click a cell in the second pivot table
Click on PivotTable Wizard
Click the Back button
Change the range back to the original ending row
Click Finish

Now you should be able to group them independently

 

[Shane Devenshire]

Hi Biro,

Here is a method that works in 2003:

1. Select the PT, and choose PivotTable, PivotTable Wizard
2. Click Back hold down the Shift key and press the Up arrow key
3. Click Next, Layout, and drag a Data field off the layout and then back
on.
4. Click OK, Back, hold down the Shift key and press the Down arrow
5. Click Finish, and answer No.

Cheers,
Shane