Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: Create a Matrix Report for Actuals Data

Example: Create a Matrix Report for Actuals Data

You want to create a matrix report that filters for actuals data that you can view on an income statement.
Security: These domains in the System functional area:
  • Custom Report Creation
  • Manage: All Custom Reports
  1. Access the
    Create Custom Report
     task.
  2. Enter
    [Subreport] Actuals
     in the
    Report Name
     field.
  3. Select:
    Option Description
    Report Type
    Matrix
    Data Source
    Journal Lines for Financial Reporting
  4. Click
    OK
    .
  5. In the
    Row Grouping
     section on the
    Matrix
     tab, select:
    Group by Field
    Sort Rows
    Cost Center
    Alphabetical - Ascending
    Fiscal Period - Actual
    Alphabetical - Ascending
    Ledger Account
    Alphabetical - Ascending
    Region
    Alphabetical - Ascending
  6. In the
    Define the Field(s) to Summarize
     section, delete the values on the populated row.
  7. Select:
    Summarization Type
    Summarization Field
    Format
    Sum
    Ledger/Budget Debit minus Credit
    #,##0.00;(#,##0.00)
  8. In the
    Filter on Instances
     section on the
    Filter
     tab, select:
    And/Or
    Field
    Operator
    Comparison Type
    Comparison Value
    And
    Accounting Date
    greater than or equal to
    Value from another field
    Time Series Start Date
    And
    Accounting Date
    less than or equal to
    Value from another field
    Time Series End Date
  9. On the
    Prompts
     tab, select the
    Populate Undefined Prompt Defaults
     check box.
  10. On the
    Prompt Defaults
     grid, select:
    Field
    Default Type
    Default Value
    Do Not Prompt at Runtime
    Company
    Specify default value
    500.1 Global Modern Services, Inc. (USA)
    Amount Type
    Specify default value
    Activity
    Select the check box.
    Ledger
    Specify default value
    Actuals
    Select the check box.
    Period
    Specify default value
    2013 - Mar
    Time Period
    Specify default value
    Current Period YTD
    Time Series End Date
    Determine default value at runtime
    Fiscal Time Period End Date
    Select the check box.
    Time Series Start Date
    Determine default value at runtime
    Fiscal Time Period Start Date
    Select the check box.
  11. For each remaining row, select the
    Do Not Prompt at Runtime
     check box.
  12. On the
    Share
     tab, click
    Share with all authorized users
    .
  13. Click
    OK
    .
When you run the matrix report, Workday displays the actuals data by the row groupings.