Create a matrix report

Create a traditional report that contains numerical data in the report output.
For information about how to create a report, see Create a custom report.

Go to the report that you created in Step 1, click Report Actions, then select Edit.

(Conditional) If you already created a View and you want o apply it to this report, click Apply an Existing View, then select the View from the drop-down list.

(Conditional) If you want to create a new View for the report, complete the following steps:

1. Click the Columns (View) tab, then select a column that you want to be summarized in the matrix report.

2. In the Column Settings area, click the Summarize this column by drop-down list, then select one of the available options for summarizing the information.

   note important
   IMPORTANT
   If this option is not selected, the information from the column is not displayed correctly in the matrix report.

   

3. Repeat this process for each column in the Columns (View) tab, then click Done.

Click the Groupings tab.

(Conditional) If you already created a Grouping and you want to apply it to this report, click Apply an Existing Grouping, then select the Grouping from the drop-down list.

(Conditional) If you want to create a new matrix Grouping for the report,complete the following steps:

1. Select Switch to Matrix Grouping in the upper-right corner of the builder interface.

2. In the Row Groupings section, identify the row grouping, which establishes the horizontal groupings of the table.

3. (Optional) To add an additional row grouping, click Add secondary Row Grouping.

4. In the Column Groupings section, identify the column grouping, which establish the vertical groupings of the table.

5. (Optional) To add an additional column grouping, click Add secondary Column Grouping.

6. (Conditional) If you add a grouping by date, also specify whether the results are grouped by day, week, month, quarter or year.
   

7. (Conditional) If you selected to group by date and to show results by quarter, for example, specify whether you want to show quarters with no data by selecting the Show quarters with no results checkbox.
   

   note note
   NOTE
   The Show quarters with no results field is only available for matrix groupings, and not for standard groupings. Only the quarters with no data that are located in-between two quarters with valid data will display zero for the data values in the matrix tab. The quarters that have no data that are located at the beginning and the end of the timeframe selected by your filter do not appear at all in the matrix grouping. The quarters with no results will not display in a grouping on the Details tab of the report.

(Optional and conditional) Click Matrix Settings, then select from the following options:
Show Record Counts: Select this option to display a row with the total number of entries for the given field.
Show Value Column: Select this option to display the following information in the matrix:

• Record Counts

• The Value column

  note note
  NOTE
  This column contains information that describes what the data in each row represents. The following exceptions apply for parent objects (for example, parent tasks) when you are aggregating values for the following fields in groupings:
  All the number and currency fields except Actual Hours (for example, Planned/ Actual Labor Cost, Planned/ Actual Expense Cost, Planned/ Actual Cost, Planned Hours) aggregate only the values for the children tasks, and standalone tasks. They do not aggregate the values for the parent tasks or parents of parents. Actual Hours aggregate the values for the main parent and the standalone tasks; they do not aggregate the numbers for the parents of parent tasks or the children tasks. Custom data fields for number and currency values aggregate all tasks: parents, children, parents of parents, and standalone tasks. If you created the matrix report to display Planned Hours or Actual Hours in the Value column, be aware that hours or cost information for any parent objects (such as parent tasks) are not displayed in the matrix report. To view hours on parent objects, you must view the Details tab.

Conditional Rules: Set up any formatting rules for values that are aggregated.
After you add a rule, you can define field and text styles for how fields that match that rule are displayed. Click Add Rule after you have finished defining the rule, then Done to save the rule.

Click the Filters tab to define what information will display in the report.

(Conditional) If you already created a Filter and you want to apply it to this report, click Apply an Existing Filter, then select the Filter from the drop-down list.

(Conditional) If you want to create a new Filter for this report, see Filter and condition modifiers

for information about the various qualifiers that you can use when building filters.

Click Save+Close to save and view the matrix report.