In Excel 2007 I have one data table, say Dates by $Sales, and want to create and save two pivot tables & their charts, one grouped to give Sales by Weeks, the other, Sales by Months. If I create the weekly tabe, then try to create the monthly table, the weekly table changes to monthly.
I could create two separate data tables, one per worksheet, and create the pivot tables & graphs on each sheet, but then I'd give up the ability to add new data to only a single master table. How can I keep the groupings in the 2 pivot tables distinct without losing the ability to update each of them when the master data table is updated?

Thanks for any tips.