+ Reply to Thread
Results 1 to 4 of 4

Dates not Grouping in Pivot

Hybrid View

  1. 04-28-2015, 03:19 PM #1
    Vicarious
    Vicarious is offline
    Registered User
    Join Date
    03-26-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    24

    Arrow Dates not Grouping in Pivot

    Why are my dates not grouping in this pivot. I am sure its simple but I cannot get it.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-28-2015, 04:18 PM #2
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Dates not Grouping in Pivot

    It's because you have blanks in your data set....you can't just remove them in the pivot, you have be more accurate in the data you select, just the 177 rows, not down to 65000....
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....
    Reply With QuoteRegister To Reply
  3. 04-28-2015, 04:28 PM #3
    Vicarious
    Vicarious is offline
    Registered User
    Join Date
    03-26-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Dates not Grouping in Pivot

    Thanks That fixed it!
    Reply With QuoteRegister To Reply
  4. 04-28-2015, 04:29 PM #4
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Dates not Grouping in Pivot

    glad I could help and thanks for the rep points....
    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 Dates-Pivot Table
    By demice in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-07-2013, 06:43 AM
  2. grouping dates in pivot table
    By lintcoop in forum Excel General
    Replies: 8
    Last Post: 01-09-2009, 03:29 PM
  3. Grouping dates in a pivot table
    By Fred Smith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2006, 10:10 PM
  4. grouping dates in pivot table
    By Charles Maronski in forum Excel General
    Replies: 2
    Last Post: 05-21-2005, 09:06 PM
  5. Grouping Dates in Pivot tables
    By Andy M in forum Excel General
    Replies: 8
    Last Post: 03-26-2005, 01: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1