Randy Johnson
asked on
2 pivot tables in the same worksheet, changing the grouping from days to month changes on both pivot tables
Excel 2013
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Accepted answer: 500 points for teylyn's comment #a40525006
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.