Different grouping settings for multiple Excel 2007 pivot tables on one worksheet

Question

I have one worksheet with 2 pivot tables, one above the other - both viewing the same data.  Data is hours per week.

I want one pivot to be 'grouped' - reflecting data by month, and one by the default by week.

When changing one pivot table properties to 'group weekly data by month' - it changes both pivots to the same setting.

I attempted to move one pivot to another worksheet in the same workbook - but the behavior was the same - change one and it changes both.

How do I get each pivot table to reflect a separate format?

EDIT:  RESOLVED/ANSWERED:

Further googling provided the answer - in Excel 2007, all pivot tables from the same data use by default the same data cache - which creates the issue.  The instructions to handle this can be found here:  http://www.pivot-table.com/grouping/pivot-table-grouping-affects-another-pivot-table

Answer 1

Posting Answer so it can be marked:

From rdarlin2: 

EDIT: RESOLVED/ANSWERED:

Further googling provided the answer - in Excel 2007, all pivot tables from the same data use by default the same data cache - which creates the issue. The instructions to handle this can be found here: http://www.pivot-table.com/grouping/pivot-table-grouping-affects-another-pivot-table

Answer 2

Glad to know that your issue is resolved and thank you for sharing the answer which would help the other users.