Saving groupings when creating new pivots?

[bergen]

Hi,

I have a monthly sales report with x amount of customers in a number of countries with an ABCDE mark. I have made a pivot table with ABCDE marks in rows and countries in Columns.
I have then grouped the countries into regions.
Looks something like this:
http://i1115.photobucket.com/albums/...berg/excel.jpg

If you can't see it look here: http://s1115.photobucket.com/albums/...rent=excel.jpg

Now my issue is that I have to compare many months of this kind of data to see movement. What I wanted to do was to display these changes but how do I do this without having to create 10 different pivot tables, and is there a way I can save the country groupings so I don't have to manually group the countries for every pivot table?

 

[Hermanito]

When you create a second pivottable from the exact same range of data, Excel will ask you if you want to re-use the Pivotcache of the first table. If you choose yes, your new pivottable will have the same groupings applied as the first table (often this is not what users want, but in your case, use it to your advantage )

Not sure how you could visualize the movement between months...