+ Reply to Thread
Results 1 to 5 of 5

Custom sort w. bracket wont apply correctly

  1. #1
    Registered User
    Join Date
    11-08-2018
    Location
    Copenhagen
    MS-Off Ver
    16.16.3 for Mac
    Posts
    6

    Custom sort w. bracket wont apply correctly

    Hello,

    I am trying to create a custom list to sort bracket values with.

    I have created a custom list with the following values:

    0-1,000
    1-2,000
    2-3,000
    3-4,000
    4-6,000
    6-8,000
    8-10,000
    10,000+

    However, when I apply the custom sort list to my pivot, it shows me the following order:

    0-1,000
    1-2,000
    10,000+
    2-3,000
    3-4,000
    4-6,000
    6-8,000
    8-10,000

    I.e. with the 10,000+ value out of order. The custom sort list has the values listed correctly, and they are all formatted as text before I created the list.

    Does anyone have an idea of why the custom sort function isn't working for me?

  2. #2
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Lima, Peru
    MS-Off Ver
    Office 365 ProPlus
    Posts
    115

    Re: Custom sort w. bracket wont apply correctly

    Change your custom list to:
    0-1,000
    1-2,000
    2-3,000
    3-4,000
    4-6,000
    6-8,000
    8-10,000
    9-10,000+
    Leo Skywalker
    May the force be with you.

  3. #3
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Lima, Peru
    MS-Off Ver
    Office 365 ProPlus
    Posts
    115

    Re: Custom sort w. bracket wont apply correctly

    1 post, hit and run...

  4. #4
    Registered User
    Join Date
    11-08-2018
    Location
    Copenhagen
    MS-Off Ver
    16.16.3 for Mac
    Posts
    6

    Re: Custom sort w. bracket wont apply correctly

    Hi LeoSkywalker,

    Sorry for the lack of response.

    The issue still persists - I create custom lists, but when I then use them to sort, the sorting does not happen according to how I entered the order.

    Point in case:
    I have created a custom sort list:
    Camper for Life (<100)
    Tent Captain (<500)
    Totem Alliance (<1,000)
    Fire Keepter (<2,000)
    Council Ring (<5,000)
    Sacehm (<10,000)


    When I then apply the sorting to a row of fields, the outcome is:
    Camper for Life (<100)
    Tent Captain (<500)
    Council Ring (<5,000)
    Fire Keepter (<2,000)
    Freddie's Circle (<20,000)
    Rising Suns (<40,000)
    Sachem (<10,000)
    Totem Alliance (<1,000)
    Trail Blazers (40,000+)

    Mads.

  5. #5
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Lima, Peru
    MS-Off Ver
    Office 365 ProPlus
    Posts
    115

    Re: Custom sort w. bracket wont apply correctly

    Post an example file.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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