See attachment.  Using these settings I'd expect my items to sort first by Sort Order.  That works.

 

For those items that have the same sort order, I'd expect those to then sort by Item, based on the second sort order of "Item".  That half works.  These are all parent level items, all with a field assigning them to this grid.  It actually does sort a lot of them alphabetically, far too many to be a coincidence.  But here and there will be items stuck where they shouldn't be, an A item right after a Q item, and so on.

 

Why?

 

And here is something that is even weirder.  If I take an item that doesn't sort correctly, let's sat that item mentioned above that starts with "A", and rename it to start with "Z" and then click refresh, it sorts properly.  But the moment I then take the Z away and put the A back, it goes back to it's seemingly random out of order position.  On the other hand if I create a brand a new item, sometimes those sort correctly, and sometimes they don't.

 

I've also tried unassigning the problem items from the grid and reassigning them with no luck either.

 

Thanks