Soru

Zorluk: KolayReport Filtering, Filter Logic, and Bucketing

A sales manager needs a report listing all Account records that currently do not have any associated active Opportunities. Which report filter feature should the administrator use to filter Accounts based on the presence or absence of related child records?

  1. Cross Filter using the 'without' relationship operatorCevap
  2. B
    Summary Formula evaluating child record counts
  3. C
    Roll-Up Summary Field filter on the parent Account object
  4. D
    Field filter with the 'includes' operator on the Opportunity field

Cevap

Cross Filter using the 'without' relationship operator
Cross Filters allow administrators to filter report results by comparing parent records against related child objects using 'with' or 'without' operators.

Adım Adım Çözüm

1
Identify the core requirement
The requirement is to display parent Account records based on the absence of related child Opportunity records.
Standard field filters evaluate individual field criteria on target records, but relationship cross-object filtering requires specialized filtering functionality.
2
Evaluate available Salesforce reporting features
Cross Filters enable reports to include or exclude parent records based on relationships to child objects (e.g., Accounts WITH or WITHOUT Opportunities).
Using a Cross Filter with 'Accounts WITHOUT Opportunities' directly satisfies the business requirement.

Anahtar Kavram

Cross Filters in Salesforce Reports
Bu soruyu puanla