AD0-E911 practice question 4 of 10

The vice president of operations asks one of their project managers to create a Workfront report that automatically sums columns so that it is similar to a Microsoft Excel file. The project manager decides to use a matrix grouping to show the data, but one of the columns isn’t showing in the report. What did the project manager forget to do?

Full set: 95 questions
Answer options
A: Summarize the columns. Correct answer
B: Update the grouping using text mode.
C: Update the conditional formatting of the column.
Correct Answer:
A. Summarize the columns.
Explanation

In Adobe Workfront, a matrix report is designed to display aggregated or summarized data, not individual row-level details. For a column to appear in the matrix view, it must be configured with a summarization function (e.g., Sum, Count, Average, Min, Max). If a column is added to the report's view but is not set to be summarized, Workfront will not display it in the final matrix output. The project manager's issue stems from failing to apply this necessary aggregation to the column.

Why Incorrect

B. Update the grouping using text mode: Text mode is an advanced method for editing report elements. The core requirement is to summarize the column, which can be done through the standard user interface without needing text mode.
C. Update the conditional formatting of the column: Conditional formatting alters the visual appearance of data (like color or style) based on specific criteria. It does not control the visibility or inclusion of a column in a matrix report.

References

1. Adobe Experience League Documentation - Create a matrix report:

Section: "Understand how columns work in a matrix report"

Content: "In a matrix report

any column that you want to display information must be aggregated. If a column is not aggregated

it does not display in the matrix view

although it is still a column in the report. For example

if you want to display the Planned Hours on a project

you must summarize the column by selecting Sum as the aggregator for this column." This directly confirms that summarization is required for a column to be visible.

Scroll to Top