There is an issue in Custom Reports where fields are available for selection as data but are not available to be sorted in the output. Example is Name(Surname, Given) is available as a data field but not available for selection for sorting. You can only select either Given Name or Surname as sort fields.
Any data column should be available for sorting in the output.
A support ticket has been submitted.