I have a table frame that I have added to my ArcGIS Pro layout. I need to sort the information on a number field that I am not actively displaying on the map in the Table Frame. Only the fields that are showing in the Table Frame are allowed to be sorted on as far as I can tell? Would be really helpful if you could sort on fields in the table regardless of whether or not they are displayed. Maybe I'm missing something?
Another option for ordering your table is to create a new one. Order the columns exactly how you want them and order the features exactly how you want them. Unfortunately you have to create a brand new table if there is any change to the order, but it does seem to work.
