Examkin

Question

Difficulty: MediumReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator at a telecommunications provider needs to build a report displaying Accounts that have active Contracts but do not have any open Cases. Additionally, executive leadership wants the report to group Accounts into three distinct spending tiers ("Enterprise", "Mid-Market", and "SMB") based on their Annual Revenue, without creating custom fields on the Account object. Which combination of reporting features should the administrator use to meet these requirements?

  1. Add a Cross Filter for Accounts WITH Contracts, add a Cross Filter for Accounts WITHOUT Cases, and create a Bucket Field based on Annual Revenue.Answer
  2. B
    Add a Row-Level Formula to check for related Contracts and Cases, and create a Summary Formula to calculate the Annual Revenue tiers.
  3. C
    Use Data Import Wizard to append bucket values directly to the Account records, and apply standard field filters with filter logic (1 AND 2) for related objects.
  4. D
    Configure a Dynamic Dashboard running user setting to filter related records, and adjust Field-Level Security to group Accounts into spending tiers.

Answer

The administrator should add a Cross Filter for Accounts WITH Contracts, a Cross Filter for Accounts WITHOUT Cases, and create a Bucket Field based on Annual Revenue.
Cross Filters allow reports to filter parent object records (Accounts) by the presence (WITH) or absence (WITHOUT) of related child object records (Contracts and Cases). Bucket Fields allow users to group numeric values like Annual Revenue into custom defined ranges ('Enterprise', 'Mid-Market', 'SMB') within the report builder without requiring custom fields.

Step-by-Step Solution

1
Identify the requirement for filtering Accounts based on related child objects (Contracts and Cases).
Determine that Cross Filters are required to filter Accounts WITH Contracts and Accounts WITHOUT Cases.
Standard field filters cannot filter parent records based on the existence or absence of related child object records.
2
Identify the requirement to categorize Accounts into spending tiers based on Annual Revenue without adding schema fields.
Determine that a Bucket Field on the numeric Annual Revenue field should be defined.
Bucket fields allow report builders to quickly categorize numerical ranges, picklists, or text fields into custom buckets directly inside the report interface without admin schema modifications.

Key Concept

Cross Filters and Bucket Fields in Salesforce Reporting
Rate this question

Topics

Report Filtering, Filter Logic, and Bucketing

More questions from this topic