Examkin

Question

Difficulty: EasyReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator needs to create an Account report that categorizes Accounts into specific size brackets based on Annual Revenue without creating custom fields on the Account object. Additionally, the report must only display Accounts that have at least one associated closed won Opportunity. Which two report features should the administrator use to satisfy these requirements? (Select TWO)

  1. Add a Bucket Field on the Annual Revenue field to define custom categories.Answer
  2. Add a Cross Filter to filter Accounts WITH Opportunities and apply secondary subfilters for the Stage.Answer
  3. C
    Create a Summary Formula field on the report to calculate the Account size brackets.
  4. D
    Create a Roll-Up Summary Field on the Account object to count related closed won Opportunities.

Answer

The administrator should use a Bucket Field on the Annual Revenue field to group accounts into size categories without custom fields, and a Cross Filter set to Accounts WITH Opportunities to filter based on related opportunity criteria.
Bucket fields provide inline grouping of ranges (like Annual Revenue tiers) without schema updates, and Cross Filters evaluate related child object criteria (like Accounts with specific Opportunities). Together, these features satisfy both requirements natively inside the report builder.

Step-by-Step Solution

1
Identify the requirement for grouping records without schema changes.
Recognize that Bucket Fields allow grouping numerical ranges or picklist values directly within report builder.
Creating custom fields in Object Manager is avoided when report bucketing meets the categorization need.
2
Identify the requirement for filtering parent records by child record criteria.
Determine that a Cross Filter configured as 'Accounts WITH Opportunities' with subfilters for closed won stage isolates the target parent records.
Standard report filters cannot evaluate child record relationships directly without Cross Filters.

Key Concept

Report Bucketing and Cross Filters
Rate this question

Topics

Report Filtering, Filter Logic, and Bucketing

More questions from this topic