Examkin

Question

Difficulty: HardReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator is tasked with configuring a custom Opportunity report to track annual cloud subscription renewals. The business requirements state:

1. Group Opportunities into three revenue tiers ('Tier 1', 'Tier 2', and 'Tier 3') based on the Amount field without modifying object metadata or creating custom fields.
2. Include Opportunities that are either in the 'Closed Won' Stage OR have an Amount greater than $100,000 with a Probability greater than 70%.
3. Restrict all report results exclusively to records where Type equals 'Cloud Subscription'.

Which TWO configuration steps must the administrator execute to fulfill these requirements? (Select TWO)

  1. Add a Bucket Field based on the Amount field to categorize records into 'Tier 1', 'Tier 2', and 'Tier 3' ranges.Answer
  2. Set the Filter Logic to (1 OR (2 AND 3)) AND 4, where 1 is Stage = Closed Won, 2 is Amount > 100000, 3 is Probability > 70%, and 4 is Type = Cloud Subscription.Answer
  3. C
    Create a Row-Level Formula on the report using summary aggregate functions to output 'Tier 1', 'Tier 2', and 'Tier 3'.
  4. D
    Set the Filter Logic to 1 OR 2 AND 3 AND 4 without parentheses to evaluate conditions sequentially from left to right.
  5. E
    Add a Cross Filter specifying Opportunities WITH Cloud Subscriptions to group records by revenue tiers.

Answer

The administrator must create a Bucket Field on the Amount field to define revenue tiers without custom schema fields, and configure custom Filter Logic formatted as (1 OR (2 AND 3)) AND 4 to enforce correct Boolean grouping across the stage, amount, probability, and type criteria.
Creating a Bucket Field directly on the Amount column satisfies the grouping requirement without requiring custom fields or Object Manager configuration. Applying filter logic structured as (1 OR (2 AND 3)) AND 4 ensures that either the Closed Won criteria or the high-value/high-probability pipeline criteria is met while mandating that every matching record belongs to the 'Cloud Subscription' Type.

Step-by-Step Solution

1
Address Requirement 1 by selecting the Amount field column menu in the report builder and choosing 'Bucket This Column'.
Defines discrete categories ('Tier 1', 'Tier 2', 'Tier 3') directly in the report without creating schema-level custom fields.
Bucket fields provide inline record categorization for text, numeric, and picklist fields inside Salesforce reports.
2
Add individual field filters for Stage, Amount, Probability, and Type in the report filter panel.
Filter 1: Stage EQUALS Closed Won; Filter 2: Amount GREATER THAN 100000; Filter 3: Probability GREATER THAN 50 (or 70); Filter 4: Type EQUALS Cloud Subscription.
Each specific condition must first exist as an individual numbered filter line before filter logic can be applied.
3
Configure Filter Logic using explicit parentheses grouping: (1 OR (2 AND 3)) AND 4.
Ensures the OR evaluation between Closed Won and high-value pipeline is isolated, while Filter 4 (Type) applies universally across all returned records.
Without explicit parentheses around the OR and inner AND statements, Salesforce standard precedence (AND before OR) returns inaccurate record sets.

Key Concept

Report Bucket Fields and Boolean Filter Logic Grouping
Estimated Time:2m 0s
Rate this question

Topics

Report Filtering, Filter Logic, and Bucketing

More questions from this topic