+ Reply to Thread
Results 1 to 8 of 8

Non-Nested Pivot Table

  1. #1
    Registered User
    Join Date
    01-18-2012
    Location
    Los Angeles USA
    MS-Off Ver
    Excel Office 365
    Posts
    80

    Non-Nested Pivot Table

    I have 3 fields (Skill1, Skill2 and LastName) in a pivot table, if I add the three fields as rows I get the following nested report. To add to the confusion Skill1 and Skill2 both have the same possible text contents; Excellent or Very Good or Good or Fair or Poor.​

    Top.png

    I would like the fields in this order Skill2 below Skill1, not have Skill2 nested under Skill1 as in the above.

    Top2.png

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Non-Nested Pivot Table

    Provide a sample of your ORIGINAL DATA to experiment with..


    Regards,
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  3. #3
    Registered User
    Join Date
    01-18-2012
    Location
    Los Angeles USA
    MS-Off Ver
    Excel Office 365
    Posts
    80

    Re: Non-Nested Pivot Table

    Here is a sample file. Thanks for the help. I am trying to set a pivot table to generate these charts.

    SkillCharts.png
    Attached Files Attached Files

  4. #4
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Cool Re: Non-Nested Pivot Table

    Refer Sheet2 for solution..
    Check the attached file..
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-18-2012
    Location
    Los Angeles USA
    MS-Off Ver
    Excel Office 365
    Posts
    80

    Re: Non-Nested Pivot Table

    The file looks like the same file I uploaded?

  6. #6
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Non-Nested Pivot Table

    No look at the sheet2 , its different..

  7. #7
    Registered User
    Join Date
    01-18-2012
    Location
    Los Angeles USA
    MS-Off Ver
    Excel Office 365
    Posts
    80

    Re: Non-Nested Pivot Table

    I show 3 tabs:

    Data
    Lists
    Chart

    When you say sheet2, do you mean the Lists tab?

  8. #8
    Registered User
    Join Date
    01-18-2012
    Location
    Los Angeles USA
    MS-Off Ver
    Excel Office 365
    Posts
    80

    Re: Non-Nested Pivot Table

    Hi
    Did you upload the correct updated spreadsheet? Thanks

+ 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. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  2. Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 03:00 PM
  3. Replies: 1
    Last Post: 06-20-2010, 04:00 AM
  4. Return pivot table range...not the data table, the PIVOT TABLE!
    By Air_Cooled_Nut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2008, 01:07 PM
  5. nested IF in calculated field in pivot table
    By Jack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-08-2006, 01:10 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