+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Grouping

Hybrid View

  1. 09-18-2015, 02:13 AM #1
    zanshin777
    zanshin777 is offline
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Pivot Table Grouping

    I want to group test scores like in the sheet1 but it gets like in the sheet2. How do I do that?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-18-2015, 02:31 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Pivot Table Grouping

    Try this

    Right Click On Any row label, for example 10-19, Field Settings > Layout & Print > Check the box for Show items with no data..
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Grouping data columns in a pivot table to create groups of stacked bars in a pivot chart
    By TomOF15 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-22-2015, 07:16 AM
  2. Excel 2007 : Pivot Table Grouping
    By mattydalton in forum Excel General
    Replies: 4
    Last Post: 04-22-2010, 06:26 AM
  3. Pivot Table Grouping
    By penumbra547 in forum Excel General
    Replies: 2
    Last Post: 05-28-2009, 12:00 AM
  4. [SOLVED] Help with Pivot table and grouping
    By bdaoust@yahoo.com in forum Excel General
    Replies: 4
    Last Post: 08-12-2006, 04:30 PM
  5. Pivot Table Grouping
    By Karen in forum Excel General
    Replies: 3
    Last Post: 08-02-2006, 04:40 PM
  6. [SOLVED] Grouping in Pivot Table
    By Piotr in forum Excel General
    Replies: 2
    Last Post: 05-17-2005, 03:06 PM
  7. [SOLVED] Pivot table grouping
    By nc in forum Excel General
    Replies: 4
    Last Post: 01-19-2005, 07:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1