A composite report sorts output based on the last column in ascending order.

In Workday composite reports, sorting behavior is controlledat the column level, not globally. Each column in a composite report can be configured with its own sort order (ascending or descending). When a composite report is sorting by the last column, it means that column has an active sort configuration applied.

To change the sort to thesecond to last columnand set it todescending, you must edit that specific column’s configuration and adjust the sort settings accordingly. Workday evaluates column sorting in sequence, and the active column-level sort determines the output order.

From the Workday HCM Reporting documentation:

“Composite reports support column-based sorting. Sorting is defined within the column configuration and determines the order in which results display.”

“To change sort behavior, update the sort settings on the appropriate column.”

The other options are incorrect because dynamic data rows control layout flexibility, combine data rows merge subreport results, and report settings manage prompts and general options—not sorting logic.