Skip to main content
Administrator Guide
Last Updated: 2023-06-23
Reference: Composite Report Cells

Reference: Composite Report Cells

You can set up these cell types in your composite report to increase the depth and focus of your report. The contents of the intersecting column and row types determine the actions available in each cell.
Cell
Description
Data
Enables you to retrieve data from your subreport at the intersection of a:
  • Calculation column and calculation row.
  • Calculation column and empty row.
  • Data column and calculation row.
  • Data column and empty row.
You can:
  • Apply additional filter data for subreports.
  • Map subreport prompts.
  • Select the
    Hide Analytic Indicator
    check box to hide analytic indicators configured on columns that impact your cells.
Executing subreports for each data cell might impact the performance of the composite report.
Calculation
Enables you to use calculation and data columns in your report to set up calculation cells that reference other cells.
You can use calculation cells with outlining.
Select the
Hide Analytic Indicator
check box to hide analytic indicators configured on columns that impact your cells.
Label
Enables you to set up labels, such as
Total Number of Employees
, at the intersection of a control column and empty row.
You can define labels using text expressions and variables. Workday replaces the variables in the text expressions with the values of the variables when the report runs. Example: Workday replaces [V1] with the date in the text expression
Last updated on [V1].
Conditional Value
Enables you to override the value of an undefined cell at the intersection of a lookup data row and data column. You can set up the cell to display zero or the actual value based on whether the condition is true or false.
Conditional Format
Enables you to override the style and visibility of an undefined cell.