+ Reply to Thread
Results 1 to 2 of 2

Sorting Dates by month, chronologically, on Pivot Table

  1. #1
    Registered User
    Join Date
    01-04-2019
    Location
    New York, NY
    MS-Off Ver
    MS Office 2013
    Posts
    8

    Sorting Dates by month, chronologically, on Pivot Table

    Hi all,

    I really hope you can help - I need to sort months in chronological order in a pivot table, and I can't make it happen.

    I have one table where all the raw data goes to; each entry has a date (i.e. 6/20/2019, 2/10/2020, etc.), then the location, category, and values. That table gets updated every time there is a new ticket.
    I use a Pivot Table to do a summary report of that data. The Pivot shows first the location, then a sum of the values, per category, per month. I have the Pivot Table designed just as I need it for the report, and it works great! With the exception of the months, all else is working just fine.

    However, when I refresh the Pivot Table, the months' sort randomly; not alphabetically, nor chronologically. I need the months to show chronologically (Sep, Oct, Nov, Dec, Jan, etc.). I've googled this issue and none of the solutions/suggestions I find fix the problem.
    I've attached a sample of the data, with a screenshot of the pivot table I am using; you can see the months are just all over the place.

    I don't know what else to do. Help?
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Sorting Dates by month, chronologically, on Pivot Table

    Add the date and then right click field and use the Group option to group by months.

    You may also need to include year in the grouping if you want the periods to be discrete
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. [SOLVED] Odd Month Sorting in Pivot Table
    By jvlachos in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 10-16-2017, 01:45 PM
  2. Pivot Table from Dates to Month
    By TCB in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-16-2015, 04:44 PM
  3. [SOLVED] Ordering chronologically in a pivot table
    By Falc in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 07-30-2013, 09:11 AM
  4. Excel 2007 : Order date chronologically in Pivot Table
    By mauricio1013 in forum Excel General
    Replies: 1
    Last Post: 12-29-2011, 04:31 AM
  5. Excel 2007 : Pivot table sum dates by month
    By pansovic in forum Excel General
    Replies: 1
    Last Post: 08-09-2011, 01:20 AM
  6. Pivot Table and Sorting by Month Only
    By Peeekay in forum Excel General
    Replies: 2
    Last Post: 11-12-2010, 11:53 AM
  7. Replies: 2
    Last Post: 06-18-2010, 03:30 PM

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