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
98 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
3 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 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 46

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

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

Suggested Solutions

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
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…

777 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