I have 2 pivot tables in 1 worksheet tab.
2 columns in each.
Grouping on date in the left column, sum of cases sold on the right.
The first pivot table has the date group by days = 7
When I go to the second pivot table to change the grouping to monthly it changes the grouping in both pivot tables.
How do I prevent this from happening?
In this worksheet which I call data I have a web query that goes out and grabs the data.
I want to have a weekly pivot table and a monthly pivot table for viewing in table format and then I want to generate graphs off both pivot tables.