Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
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
?
132 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
2 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 50

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

This is an article on how to answer questions, earn points and become an expert.
If Skype for Business came with your office 2016 or office 365 installation, you may find that it's almost impossible to either disable or remove it. The application will often launch with each start of Windows, even when explicitly configured not t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

581 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