Cannot sort by choice field value in report

Debbi L
Tera Expert

I have a report that shows open requests on a custom table. It's a bar chart, grouped by Aging Category, and sorted on that same field (a-z). The values are 0-8, labels are plain English. I would expect, based upon everything I've found to date in these forums, that it would use the values to sort, and not the labels. However, I'm finding the reverse to be true. Has anyone seen this? And, if so, have you found a fix?

This is the choice list:

DebbiL_0-1725992820845.png

 

This is the resulting report:

DebbiL_1-1725992839772.png

 

0 REPLIES 0