nerdexam
Salesforce

CRT-211 · Question #145

Management at Ursa Major Solar wants to understand how many accounts have opportunities in the overall pipeline. What should the administrator use to create a report showing all open opportunities…

The correct answer is D. The Show Unique Count option on the account name column. The Show Unique Count option on the account name column will create a report showing all open opportunities and the total number of accounts represented. This option will count each account only once, even if it has multiple opportunities. The report can be grouped by account…

Analytics

Question

Management at Ursa Major Solar wants to understand how many accounts have opportunities in the overall pipeline. What should the administrator use to create a report showing all open opportunities and the total number of accounts represented?

Options

  • AThe row count on a summary report grouped by account name
  • BA Cross Filter selecting opportunities with accounts
  • CA custom report type showing opportunities with accounts
  • DThe Show Unique Count option on the account name column

How the community answered

(35 responses)
  • A
    14% (5)
  • B
    3% (1)
  • C
    6% (2)
  • D
    77% (27)

Explanation

The Show Unique Count option on the account name column will create a report showing all open opportunities and the total number of accounts represented. This option will count each account only once, even if it has multiple opportunities. The report can be grouped by account name or any other field to show more details.

Topics

#summary reports#unique count#opportunity pipeline#report columns

Community Discussion

No community discussion yet for this question.

Full CRT-211 Practice