QuestionQ20

Execute

An executive needs to view the actual cost of projects in a selected portfolio, with the ability to run multiple reports and choose a particular portfolio, sorted in descending order so the highest-cost projects are shown first.

Which steps should be taken to create this report?

  • 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.
  • 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.
Explanation

A Project report can show Actual Cost for each project and sort that column in descending order so the most expensive projects appear first. A Portfolio Name prompt lets users select a different portfolio whenever they run the report, making the report reusable across portfolios. Adobe Workfront distinguishes prompts from fixed filters because prompts can be applied differently each time a report is run.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!