Thank you for the answer but it does not address my problem...
"Because you created the two pivot tables from the same source data, by default they use the same pivot cache, the grouped items are the same in both tables. "
I do want the same groups in the tables, but if I RENAME a group in...
Case:
Suppose I make two pivot tables based on the same source data. (both tables use the same data cache).
If I make a group in the one table, the same grouping appears in the other table as well.(so far so good)
Problem:
If I try to rename the default name "Group 1" in the pivot table1...