+ Reply to Thread
Results 1 to 3 of 3

Do not group similar items together - PIVOT TABLE

  1. #1
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,691

    Do not group similar items together - PIVOT TABLE

    Hey there,

    I have no experience with Pivot Tables and so I need your assistance regarding a very basic issue.
    In the file attached you can see that similar dates in column A are grouped together in the Pivot Table. I just want pivot table to show all individual rows instead of grouping similar items together.

    I really appreciate your assistance
    Attached Files Attached Files
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  2. #2
    Registered User
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    Office 365
    Posts
    67

    Re: Do not group similar items together - PIVOT TABLE

    Hi Sourabh,

    In your PT, right click in the Date field, go to Field Settings, on the Layout & Print tab check the Repeat Item Labels box. Hope that fixes you up.

  3. #3
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,691

    Re: Do not group similar items together - PIVOT TABLE

    Hi,
    Thank you for your response.
    I think that this option is unavailable in EXCEL 2007 which I am using.
    Any thoughts?

+ 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. Filter pivot items using pivot items from another table
    By DKolev in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2014, 08:49 PM
  2. Replies: 1
    Last Post: 09-03-2012, 10:03 PM
  3. Grouping similar but not exact items in Pivot Table
    By RobLaw in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-19-2011, 05:20 PM
  4. Pivot Table or something similar?
    By archi in forum Excel General
    Replies: 2
    Last Post: 09-12-2009, 01:57 AM
  5. Is there a way to Group similar items on the X axis?
    By hkUSATV in forum Excel General
    Replies: 5
    Last Post: 12-11-2008, 09:44 AM
  6. group items in pivot table
    By minkus in forum Excel General
    Replies: 1
    Last Post: 09-30-2007, 08:35 PM
  7. Can't group pivot table items by month in Excel
    By scott_ensley in forum Excel General
    Replies: 1
    Last Post: 02-01-2005, 05:06 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