Examkin

Question

Difficulty: MediumReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator at a global freight logistics company is tasked with creating an Account report. Leadership requires the report to categorize accounts into three distinct revenue brackets (Small, Medium, and Enterprise) directly within the report interface without creating a custom field on the Account object. In addition, the report must display only Accounts that currently have open Opportunities and do not have any open Cases. Which combination of reporting features should the administrator use to satisfy these requirements?

  1. Add a Bucket Field based on the Annual Revenue field, add a Cross Filter for Accounts with Opportunities, and add a second Cross Filter for Accounts without Cases.Answer
  2. B
    Create a Summary Formula field on Annual Revenue to group records into revenue brackets, and use standard field filter logic to check related Cases.
  3. C
    Create a Roll-Up Summary field on the Account object to group revenue brackets, and apply record type filtering to isolate accounts with active opportunities.
  4. D
    Configure a dynamic dashboard running user setting to filter account revenue categories, and use a row-level formula to exclude accounts with open cases.

Answer

Add a Bucket Field based on the Annual Revenue field to group accounts into revenue brackets without creating schema fields, alongside two Cross Filters (Accounts with Opportunities, Accounts without Cases) to enforce the related record requirements.
The correct answer combines a Bucket Field on Annual Revenue to categorize records into ranges directly within the report builder with two Cross Filters ('Accounts with Opportunities' and 'Accounts without Cases') to filter parent records based on child object existence.

Step-by-Step Solution

1
Determine the requirement for categorizing accounts without custom schema fields
Identify Bucket Fields as the standard Salesforce report feature that groups numeric values (such as Annual Revenue) into defined ranges inline within reports.
Creating custom fields on the object is explicitly restricted by business requirements.
2
Evaluate filtering criteria for related child records (Opportunities and Cases)
Apply Cross Filters on the Account report: 'Accounts with Opportunities' and 'Accounts without Cases'.
Cross filters are designed to include or exclude parent records based on related child object conditions.

Key Concept

Report Bucketing and Cross Filters
Rate this question

Topics

Report Filtering, Filter Logic, and Bucketing

More questions from this topic