+ Reply to Thread
Results 1 to 3 of 3

Sort weeks in pivot table

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    142

    Sort weeks in pivot table

    Hello,

    I'm trying to build a pivot table with rows as weeks. Here is an example of what I'm looking for: The file I've uploaded has sorted it based on the week number. How can I sort and get the result below.

    Week 1
    Week 2
    Week 3
    etc.
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Sort weeks in pivot table

    Personally, I would remove "Week " in your data so that you are just left with the numbers. Then the PivotTable will sort as expected.

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Sort weeks in pivot table

    or change in source table Week 1 to Week 01 etc then sort PT by A-Z

+ 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. How to insert all 100 weeks in to pivot table values?
    By sovietchild in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-14-2017, 05:38 PM
  2. [SOLVED] Pivot Table Months Weeks
    By morerockin in forum Excel General
    Replies: 3
    Last Post: 04-22-2017, 09:13 PM
  3. Replies: 4
    Last Post: 02-19-2016, 05:08 PM
  4. Pivot Table in Weeks Tuesday thru Monday Adjustment
    By johnsor1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-12-2015, 03:45 PM
  5. VBA to Select Multiple Weeks in Pivot Table based on User Input
    By burrow.philip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2014, 11:36 AM
  6. Macro to select rolling/latest 6 weeks in a pivot table
    By prasannakr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2013, 03:59 AM
  7. Grouping Weeks to Month in Pivot Table
    By himanshututeja in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-18-2012, 01:59 PM

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