Is it possible to add a column and order the data by it then hide it?

Hello,
 
Thank you for reaching out to us.
 
Flexmonster only allows sorting by the columns present on the grid.
 
Still, we suggest checking out the following workarounds that may be helpful for your case:
 
After sorting by the desired column, set its width to 0 using the Table Sizes Object. It will hide the chosen column from the grid and preserve sorting. The Table Sizes Object can be predefined in the report or applied afterward using the setTableSizes API call.
 
Another approach is to use the sortingMethod. This approach can be used in case you know the required order of members in advance (for example, passed as a sorted array). Still, the sortingMethod will not help if you want to rely on sorting performed by Flexmonster.
 
Please let us know if it helps.
 
Kind regards,
Illia