Skip to main content
Administrator Guide
Last Updated: 2023-06-23
Concept: Logical Sort Order

Concept: Logical Sort Order

Logical sorting enables Workday to sort your data based on the leftmost column of the report and display your data in a manner that makes sense. Example: Instead of sorting the months alphabetically, you can understand how your data changes over time by sorting logically, such as January, February, and so on. Ordinarily, Workday first sorts data based on the primary business object, then sorts the related business objects according to the contextual relationship to the primary business object. You can use calculated fields to sort by the related business object first.
Your field selection determines if logical sorting is available. Workday enables logical sorting for the lookup range band calculated field and for these report types:
Report Type
Description
Composite
Enable logical sorting for combine data rows.
Matrix and trending
On the
Create Custom Report
task, enable logical sorting on the:
  • Matrix
    tab for column and row grouping.
  • Drill Down
    tab for the
    Drillable Fields
    grid and the
    Sort
    section.
Simple and transposed
Enable logical sorting by accessing the
Sort
tab on the
Create Custom Report
task.