+ Reply to Thread
Results 1 to 8 of 8

Monthwise Sorting Not Working in Pivot Table

  1. #1
    Forum Contributor
    Join Date
    04-18-2016
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    139

    Monthwise Sorting Not Working in Pivot Table

    Dear All,

    The Column C is having Dates, Column D with forumula =TEXT(C2, "MMM-yy;;") to get the Month name. When I create Pivot table it shows as below:
    Apr-16
    Dec-15
    Feb-16
    Jan-16
    Jun-16
    Mar-16
    May-16
    Nov-15
    Oct-15
    Sep-15

    This should be starting with Sep-15 and ending with Jun-16.

    Can anyone help me on this.

    Gem

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Monthwise Sorting Not Working in Pivot Table

    why not use: yyyy-mm ?

    if this is not working for you add the excel file, without confidential information.

    edit

    or even better, split the year and month in separated columns.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    04-18-2016
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    139

    Re: Monthwise Sorting Not Working in Pivot Table

    Still not working.. Please see the attached sheet...

    Gem
    Attached Files Attached Files

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,607

    Re: Monthwise Sorting Not Working in Pivot Table

    Delete column C from your source data. Just use the Date column in your pivot table, then right-click it, choose Group, and group by year and month.

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Monthwise Sorting Not Working in Pivot Table

    it works for me, but you have to change the yyyy-mmm in your formula into (as already offered) yyyy-mm

    see the attached file.

  6. #6
    Forum Contributor
    Join Date
    04-18-2016
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    139

    Re: Monthwise Sorting Not Working in Pivot Table

    Rorya - When I group by year & month, year & month are shown in two different columns.

    Oeldere - I wanted the month to be display by name instead of numbers. For eg.. Apr-16, May-16

    Gem

  7. #7
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,607

    Re: Monthwise Sorting Not Working in Pivot Table

    Is that really an issue? (and if so, why?) It is by far the simplest solution IMO.

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Monthwise Sorting Not Working in Pivot Table

    Oeldere - I wanted the month to be display by name instead of numbers. For eg.. Apr-16, May-16
    I appreciate it if you post it on the forum, if you found that pivottable solution.

+ 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. Sorting a table with a macro - code not working
    By MikeRoot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2014, 04:40 PM
  2. Pivot Table select all Pivot Items not working as intended
    By rasonline in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2014, 05:22 PM
  3. [SOLVED] Sorting a pivot table and data outside of the table
    By nicki_rae22 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-06-2013, 12:57 PM
  4. Replies: 0
    Last Post: 01-19-2013, 06:57 AM
  5. Sorting Dates in a Pivot Table is not working
    By Excel_vba in forum Excel General
    Replies: 1
    Last Post: 10-09-2012, 02:31 PM
  6. Excel 2007 : pivot table sorting
    By Kolacube in forum Excel General
    Replies: 0
    Last Post: 03-24-2011, 03:30 AM
  7. Sorting Dates MonthWise and getting Unique Values
    By e4excel in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-06-2011, 05:10 AM

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