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?
Bookmarks