+ Reply to Thread
Results 1 to 1 of 1

Trouble with Grouping by Year/Month in Pivot Table

  1. #1
    Registered User
    Join Date
    04-13-2010
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2007
    Posts
    1

    Trouble with Grouping by Year/Month in Pivot Table

    I created a pivot table based off data being retrieved from a SQL Server query in March and grouped the results by Year/Month so it showed Jan, Feb, March for 2010. When I refreshed it today, for 2010 it shows Jan, Feb, March, and >3/27/2010.

    Why didn't it group the >3/27/2010 data into March and April separately?

    Thanks for any help.
    Last edited by mr_bear; 04-13-2010 at 03:30 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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