Excel 2010: Multiple Pivot Tables Grouping, change grouping other Pivot Tables.

[Sweetworks]

Hello,

I've created some reports in Excel. I have one sheet that has all the raw data, and then a separate sheet for like 6 different reports.

Each report is a simple pivot table. I am able to group it by Month for some reports and by day (7 days with a Sunday starting date) for other reports.
I then do a graph off the pivot table.

I am trying to show a report with weekly and monthly data. I am trying to create two different Pivot tables one to group by week and one by month.
So I created a new pivot table from scratch (same set up) and when I change the grouping it changes it for all the other pivot tables.

Is their a way to keep the grouping left as is on the pivot tables.

My only solution I can think of is create 3 files. One with the Raw data, and one with grouping by months and one with grouping by weeks.
I'd prefer to keep it contained in one file.

 

[combo]

Looks like your pivot tables are linked - the second uses first pivot table as its data source. Create the second table from scratch again, choose the option to use the same data source independently.

combo