+ Reply to Thread
Results 1 to 5 of 5

Pivot: same data in two columns

  1. #1
    Registered User
    Join Date
    02-11-2009
    Location
    Zagreb, Croatia
    MS-Off Ver
    Excel 2003
    Posts
    10

    Pivot: same data in two columns

    Hi everyone!

    I would like to show the same set of data grouped by two criteria but subgrouping them.

    When I put my data in the data area, and the criteria (crit1, crit2) in the column fields area I get the values grouped first by crit1 and than subgrouped by crit2. What I would like to see is grouping by both criteria independently, first by one and than by the other, without subgroupinig.
    Hope it's not too confusing :-)

    Up to now, I've been solving that by multiple pivot tables. Is there any way to do the same? Thanks!
    Last edited by rykobyk; 02-20-2009 at 06:16 AM.

  2. #2
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264

    Re: Pivot: same data in two columns

    Hi & Welcome to Excel Forum!

    Would you mind posting a sample workbook with the pivot table you currently have (strip out any confidential data and reduce the file size if required) and a brief diagram showing the output you actually want. This will make it much easier for us to provide a suitable solution. Thanks!

    Richard
    Richard Schollar
    Microsoft MVP - Excel

  3. #3
    Registered User
    Join Date
    02-11-2009
    Location
    Zagreb, Croatia
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Pivot: same data in two columns

    I thought that my description won't be much intuitive :-)
    Here's the example. Column N is hidden just to achieve the layout I wanted.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264

    Re: Pivot: same data in two columns

    Thanks for the sample

    I can see what you want but I suspect you already have the solution (ie use two pivot tables artificially joined together). I don't *think* you will get your desired result using only a single pivot table. Would love to be proved worng though!

  5. #5
    Registered User
    Join Date
    02-11-2009
    Location
    Zagreb, Croatia
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Pivot: same data in two columns

    Thank you for your effort! Hoped maybe someone would try to prove you wrong... :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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