A composite report sorts output based on the last column in ascending order. You want the sort to be based on the second to last column in descending…

In Workday composite reports, the primary sort order for the report's output is defined directly on the columns within the report layout. To change which column controls the sort and in what direction, you must edit the specific column's properties. The process involves removing the existing sort from the last column and then editing the second-to-last column to add a new sort with the direction set to "Descending". Therefore, editing the column is the direct and correct method to achieve the desired change in sorting behavior.

A. Edit the combine data row.

The combine data row is used to aggregate data from subreports into a single row for summarization, not for controlling the overall sort order of the report output.

C. Create a dynamic data row.

Dynamic data rows are used to generate multiple rows of data based on a driving business object, which is unrelated to setting the primary sort column for the report.

D. Update the report settings.

The main report settings (e.g., on the Advanced tab) for a composite report do not control the column-level sorting; this is configured within the individual column definitions.

1. Workday Reporting & Analytics Documentation: The configuration of sorting for composite reports is managed at the column level. The "Create Composite Report" task guide specifies that sorting is applied by editing a column and setting the 'Sort Type' (Ascending/Descending) and 'Sort Priority'. To change the sort

the user must modify these settings on the relevant column. (Reference: Workday Community

"Create Composite Report Task

" Section: Configure Columns).

2. Workday Training Courseware

"Composite Reporting": University-level and official Workday training materials emphasize that the structure and behavior of a composite report

including sorting

are defined by its rows and columns. The primary sort is a column property. (Reference: Workday Pro HCM Reporting Training Manual

Module: "Advanced Composite Report Design

" Topic: "Sorting and Grouping").