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 questionsThis 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.
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.
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").
Keep practicing
Take the free AD0-E903 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other AD0-E903 practice questions
- Question 1Which two options are available with Workfront reports? (Choose two.)
- Question 2A marketing team determines that in the future, their projects must be reviewed by the Pr…
- Question 3Which project Condition is set when the Progress Status of the project is Behind or At Ri…
- Question 4What are two ways to associate milestone steps to tasks? (Choose two.)
- Question 5A team member has five days to complete a critical path task, and the task requires only …
- Question 6How would a project manager create a custom Workfront report to show information about is…
