MENU
You are configuring a matrix report that groups average performance ratings by supervisory organization. However, the report users would like to be able to drill down and view data at each level of the hierarchy. How should you edit the report definition to achieve this functionality?
Matrix reports in Workday allow grouping and summarization of data, but to drill down through hierarchical structures such as supervisory organizations, you must configure hierarchy-aware calculated fields. The Lookup Hierarchy Rollup function enables drillable hierarchies, showing performance metrics at each level of the organizational tree.
The Workday binder notes: ''Matrix reports allow you to group data, summarize the metrics for each grouping, and drill into the summarizations for further analysis.'' . This means you can expand results from the top supervisory org down to teams and individual workers.
Using a simple Lookup Related Value would only pull in one field from a related object, not enable hierarchical drill-down. Similarly, changing sort order or adding overrides does not create drillable hierarchies. Only Lookup Hierarchy Rollup enables this behavior.