+ Reply to Thread
Results 1 to 5 of 5

how to sort Week no- Year (04-2018, 05-2019, 07-2018) in pivot chart.

  1. #1
    Registered User
    Join Date
    04-03-2014
    Location
    bangalore
    MS-Off Ver
    Excel 2007/10
    Posts
    7

    Post how to sort Week no- Year (04-2018, 05-2019, 07-2018) in pivot chart.

    I am having sheet with pivot chart. Row header containing Wk #-Year (04-2018, 06-23018, 04-2019, 09-2019 so on). When I tried to sort in pivot, it is sorting with respect to week number only not considering the year.

    snip.JPG

    Please help me to sort properly.

    Advance thanks..!!

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: how to sort Week no- Year (04-2018, 05-2019, 07-2018) in pivot chart.

    Is it possible to list the year first then week number?

    Then the sort would work.

    What I mean is can you reformat the date field to use the format YYYY-WN before importing the data into the pivot?

  3. #3
    Registered User
    Join Date
    04-03-2014
    Location
    bangalore
    MS-Off Ver
    Excel 2007/10
    Posts
    7

    Re: how to sort Week no- Year (04-2018, 05-2019, 07-2018) in pivot chart.

    I will try. Thaks

  4. #4
    Registered User
    Join Date
    04-03-2014
    Location
    bangalore
    MS-Off Ver
    Excel 2007/10
    Posts
    7

    Re: how to sort Week no- Year (04-2018, 05-2019, 07-2018) in pivot chart.

    I tried your suggested method and it is not sorting properly.

    captureg.JPG

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: how to sort Week no- Year (04-2018, 05-2019, 07-2018) in pivot chart.

    You need to make sure the week number is always formatted with 2 digits- so 2018-04 rather than 2018-4
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Call in the Cavalry - 2018
    By AliGW in forum The Water Cooler
    Replies: 152
    Last Post: 01-10-2019, 12:06 PM
  2. Datepicker for 2018 formatting formula help
    By JohnGreen2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-29-2017, 12:34 PM
  3. [SOLVED] Formula to calculate no. Of working days for the year 2018
    By gko_87 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-26-2017, 06:00 AM
  4. employees hiliday planner 2018
    By fly2waleed in forum Excel General
    Replies: 1
    Last Post: 12-11-2017, 06:53 AM
  5. Fiscal Year 2018 ( Feb 4, 2017 - Feb 3, 2018)
    By chethan1333 in forum Excel General
    Replies: 1
    Last Post: 05-09-2017, 08:40 AM

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