+ Reply to Thread
Results 1 to 3 of 3

Multiple Pivots - separate grouping

  1. #1
    Registered User
    Join Date
    07-28-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    30

    Multiple Pivots - separate grouping

    Hi,

    I have the multiple pivot tables in the spreadsheet with date as a main row label. When I change grouping in one table (i.e. by month) - it automatically changes grouping in another table.
    Is there any way to keep grouping separate?
    I'm working with Excel 2007.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,212

    Re: Multiple Pivots - separate grouping

    You have to base your pivots on separate caches - since 2007 excel by default makes next pivot from the same dataset using a common cache thus gruping or filtering in one pivot influences other. You coudl call "old (ex2003-) style pivot creator with keyboard shortcut Alt D P - which comes from the Excel 2003 menu bar: Alt - D = Data menu, then P to select the Pivot chart wizard. See also http://office.microsoft.com/en-gb/ex...010226675.aspx and http://gasperkamensek.wordpress.com/...e-pivottables/
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    07-28-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Multiple Pivots - separate grouping

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA - 1 pivot filter control multiple pivots with multiple field options
    By bwolsky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2014, 06:19 PM
  2. [SOLVED] Insert Slicer for Pivots Only or can we use it for Charts without Pivots?
    By eldwardo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2013, 04:27 AM
  3. [SOLVED] Grouping events based on Time Intervals in Pivots
    By hutch2hutch in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-13-2013, 05:10 AM
  4. [SOLVED] Changing grouping on one one pivot table affects other pivots - no good
    By andylists@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2013, 12:13 AM
  5. separate worksheet into multiple worksheets by grouping
    By BPM001 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-04-2005, 10:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1