Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts

    Custom Sort in Pivot Table

    I have a data source that has an ID number Plot and a District Number (D1..D8..D14)
    Plot 102 D1 area 1
    Plot 102 D1 area 2
    Plot 173 D1 area 1
    Plot 173 D1 area 2
    Plot 175 D1 area 1
    Plot 175 D1 area 2
    Plot 110 D8 area 1
    Plot 110 D8 area 2
    Plot 110 D8 area 3
    Plot 110 D14 area 1
    Plot 110 D14 area 2

    When I create a pivot table it sorts by the Plot number. How can I get the pivot table to sort by District like the data source?
    Thanks!
    Last edited by MOSTATE; 2015-12-02 at 12:19. Reason: Data did not display

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Make the district number the first field in the row field area.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts
    Thanks for the reply, Rory. Unfortunately, the label is one continuous text string "Plot 102 D1 area 1" but I think I am just going to use the MID function to pull out the district and use that to sort in the PivotTable.

    Thanks!

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Ah. You might want to post a workbook, or a table, next time - that really wasn't clear (to me anyway) from your post.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. The Following User Says Thank You to rory For This Useful Post:

    MOSTATE (2015-12-04)

  6. #5
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts
    Yes, posting a sample worksheet would have made it much easier to understand my issue. Will keep that in mind next time...thanks again!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •