Examkin

Question

Difficulty: HardReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator at a medical device manufacturer is building a report on Account records to support an upcoming service contract renewal campaign. The operational leadership team has specified two primary requirements:
1. Group Accounts into three custom volume tiers ('Enterprise', 'Mid-Market', and 'Small Business') based on the standard Account Source picklist values without modifying schema or adding custom fields.
2. Filter the report to display Accounts that have related active Service Contracts, but do NOT have any open high-priority Support Cases.

Which TWO configuration choices or platform constraints must the administrator account for when building this report? (Select TWO.)

  1. Bucket fields can be defined on Picklist, Text, or Numeric fields to group values into custom categories directly within the report builder.Answer
  2. Cross Filters allow filtering parent Accounts with Service Contracts (subfiltered by Status = Active) and Cross Filters without Cases (subfiltered by Priority = High and Status != Closed).Answer
  3. C
    A Bucket Field can evaluate data from parent and child relationship objects simultaneously using standard summary formula calculations.
  4. D
    A single Cross Filter block can query up to five distinct child objects at the same time without needing separate filter entries.

Answer

The administrator must utilize a Bucket Field on the Account Source picklist field to categorize accounts into custom tiers without schema modifications, and apply dual Cross Filters (Accounts WITH Service Contracts subfiltered by Status, and Accounts WITHOUT Cases subfiltered by Priority and Status) to satisfy the filtering criteria.
The correct options accurately identify that Bucket Fields can be created directly on picklist fields to categorize values without modifying object schema, and that complex parent-child criteria require combining 'WITH' and 'WITHOUT' Cross Filters with specific subfilters.

Step-by-Step Solution

1
Evaluate the bucketing requirement
Confirm that Bucket Fields support Picklist fields directly in report builder without adding custom fields on the Account object.
Bucket fields provide an inline report-level transformation tool for Picklist, Text, and Number fields.
2
Evaluate the relationship filtering requirement
Configure two separate Cross Filters: one for 'Accounts WITH Service Contracts' (subfiltered by Active status) and another for 'Accounts WITHOUT Cases' (subfiltered by High priority open cases).
Salesforce reports require distinct Cross Filters to specify separate WITH and WITHOUT child object logic.
3
Verify feature limits and invalid configurations
Rule out using bucket fields for cross-object summary logic or expecting a single cross filter block to evaluate multiple child objects simultaneously.
Bucket fields operate row-by-row on single fields, and each Cross Filter evaluates only one related child object.

Key Concept

Report Bucketing and Cross Filter Logic
Rate this question

Topics

Report Filtering, Filter Logic, and Bucketing

More questions from this topic