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?