AD0-E903 practice question 7 of 15

An executive wants to see the actual cost of projects within a selected portfolio, allowing for multiple reports with the option to select a specific portfolio, sorted in a descending order, so the most expensive projects appear on top. Which steps should be taken to create this report?

Full set: 70 questions
Answer options
A: Visit the Reports area and create a new Project report. Add a column for Actual Cost and sort the column in descending order. From the Reporting Settings dropdown, add a prompt for Portfolio Name. Correct answer
B: Visit the Reports area and create a new Project report. Group the results by Portfolio Name. Add a column for Actual Cost and summarize this column by SUM.
C: Visit the Reports area and create a new Project report. Add a column for Actual Cost and sort the column in descending order. Group the results by Portfolio Name.
Correct Answer:
A. Visit the Reports area and create a new Project report. Add a column for Actual Cost and sort the column in descending order. From the Reporting Settings dropdown, add a prompt for Portfolio Name.
Explanation

This approach correctly addresses all requirements. Creating a Project report is the correct starting point. Adding the 'Actual Cost' column and sorting it in descending order fulfills the request to see the most expensive projects first. Most importantly, adding a prompt for 'Portfolio Name' from the Report Settings is the specific function that allows a user to select a single, specific portfolio each time the report is run. This makes the report reusable for any portfolio as requested by the executive.

Why Incorrect

B. Grouping and summarizing by SUM would show the total cost for all portfolios, not the individual project costs within a single, selected portfolio as requested.
C. Grouping by Portfolio Name displays all portfolios in the same report, which does not meet the requirement to select and view a single, specific portfolio.

References

1. Adobe Experience League Documentation - Create a custom report: This document outlines the initial steps for report creation. The scenario starts with creating a new Project report, which is the foundational step. (See section "Create a report").

2. Adobe Experience League Documentation - Add a prompt to a report: This source details how to add prompts, which are essential for user-selectable criteria. The document states, "You can add a prompt to a report to allow people who view the report to specify a filter for the information they see." This directly supports using a prompt for 'Portfolio Name'. (See section "Add a prompt to a report").

3. Adobe Experience League Documentation - Edit report settings: This guide explains how to access the settings to modify a report, including adding prompts. The path described in option A, "From the Reporting Settings dropdown, add a prompt," aligns with the UI described here. (See section "Report Settings area").

4. Adobe Experience League Documentation - Sort information in a list: This document confirms the ability to sort columns in reports. It explains how to apply a descending sort to a column like 'Actual Cost' to list the highest values at the top. (See section "Sort by one column").

Scroll to Top