?
Solved

2 pivot tables in the same worksheet, changing the grouping from days to month changes on both pivot tables

Posted on 2014-12-30
3
Medium Priority
?
104 Views
Last Modified: 2015-01-23
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.
0
Comment
Question by:rjohnsonjr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 40525006
Hello,

By default, Excel will pull the two pivot tables from the same pivot cache. Grouping by a date field will be applied to the pivot cache and will affect all pivot tables that are drawn from that pivot cache.

To create a pivot table that is independent of the first pivot table, you need to use the pivot table wizard. You can use the keyboard shortcut Alt-D-P to start the pivot table wizard. You may get a warning about existing pivot tables and saving memory by using existing pivot tables. That is where you need to tell Excel that you want to create a new pivot table. If you click "No" the new pivot table will use a different pivot cache and you can create different groupings on that pivot table.

Be aware that for large data sets this will have an impact on the workbook size and memory, because both pivot caches will be loaded into the memory.

cheers, teylyn
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 40567773
I've requested that this question be closed as follows:

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.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question