+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Grouping / Nesting Question

  1. #1
    Registered User
    Join Date
    03-27-2009
    Location
    Boston, United States
    MS-Off Ver
    Excel 2003
    Posts
    12

    Pivot Table Grouping / Nesting Question

    I am having an issue with getting a Pivot Table to display data how I would like to report on it. The column labels are fine, and when I put one field into the row label section, I see data how I would like to. When I add another field to the Row Label section, it nests this within the first question, where I really just want to keep them grouped seperately by field and display in one table. I think the graphics below will help explain this better.


    Pivot Table with 1 field for the row & column sections, which is fine

    pivot1.jpg


    When I add the second field in, the fields 'nest', whereas I would like them to 'group':


    pivot2.jpg


    Ideally, I would like them to stay grouped by each field, similiar to below (This is all hardcoded, I just wanted to show my ideal output):


    pivot3.jpg


    I have been banging my head against this for hours now, and would really appreciate any help. Thanks!

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Pivot Table Grouping / Nesting Question

    x-posted: http://www.mrexcel.com/forum/showthread.php?t=474964

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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