+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Not Sorting "Wk_1" through "Wk_52" Correctly

  1. #1
    Registered User
    Join Date
    10-21-2016
    Location
    Kansas City, MO
    MS-Off Ver
    2010, 2013
    Posts
    58

    Pivot Table Not Sorting "Wk_1" through "Wk_52" Correctly

    I am building a YoY sales graph for work and have been asked to use the format "Wk_1", "Wk_2", etc. as my charting values. I build the graph off of a pivot table since I do not need all of 2018 sales - just those from Wk_1 through last week 2019 (Wk_37) (since this is a weekly chart, I will cap the pivot at Week 37 and next week extend to 38, 39, etc.).

    However, my weeks are sorting alphabetically as "Wk_1", "Wk_10", "Wk_11", etc. I get this is a string, but there's some way to arrange these in order since I've seen charts at my company with this formatting. We recently switched from Office 2010 to 2016, so maybe the process is different. If anyone can get it to work in the attached and advise how, I'd be grateful!
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    1,849

    Re: Pivot Table Not Sorting "Wk_1" through "Wk_52" Correctly

    Are you able to change Wk_1 into Wk_01? It sorts all problems.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    10-21-2016
    Location
    Kansas City, MO
    MS-Off Ver
    2010, 2013
    Posts
    58

    Re: Pivot Table Not Sorting "Wk_1" through "Wk_52" Correctly

    Thanks, this was approved! Still not sure why it does not work for me the other way, though, since it used to.

+ 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. Replies: 7
    Last Post: 03-06-2019, 05:01 PM
  2. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  3. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  4. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  5. Replies: 0
    Last Post: 10-21-2013, 05:06 PM
  6. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  7. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 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