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

Example: Create a Matrix Report for Plan Data

You want to create a matrix report that filters for plan 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] Plan
     in the
    Report Name
     field.
  3. Select:
    Option Description
    Report Type
    Matrix
    Data Source
    Plan 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 - Budget
    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
    Plan Period Start Date
    greater than or equal to
    Value from another field
    Time Series Start Date
    And
    Plan Period End Date
    less than or equal to
    Value from another field
    Time Series End Date
    And
    Cost Center Hierarchies
    any in the selection list
    Value specified in this filter
    20.0 Finance
    30.0 Human Resources
    40.0 Information Technology
    50.0 Operations
    60.0 Sales & Marketing
  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)
    Plan Structure
    Specify default value
    Budget
    Select the check box.
    Amount Type
    Specify default value
    Activity
    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.
    Ledger Account/Summary
    Specify default value
    Corporate: Income Statement
    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 plan data by the row groupings.