+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Sort by date

  1. #1
    Registered User
    Join Date
    03-30-2004
    Location
    Scotland
    Posts
    1

    Pivot Table Sort by date

    Need to sort my pivot table by month_year have tried field setting > advanced > using field > month_year but still the dates are muddled up in there order..help appreciated.

    this is what i am getting

    2_2005
    12_2004
    11_2004
    1_2005

  2. #2
    Forum Contributor
    Join Date
    12-02-2004
    Location
    London
    Posts
    255
    I would guess that Excel is interpreting the values you have as Text values, rather than dates, check your source data to see if the values are stored as dates, if not either change them into dates or create a new column, which converts the current field (2_2005, 12_2004 etc) into a date.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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