SALESFORCE-ASSOCIATE practice question 6 of 25

A sales manager at Get Cloudy Consulting wants a report that shows their top-selling product families by quantity.

Full set: 123 questions
Answer options
A: Group by opportunity stage> Filter by product family > Sum the total number sold
B: Group by product family > Filter to show only Closed Won opportunities >Sum the total number sold Correct answer
C: Croup by active products > Filter to show opportunities this year > Sum the quantity
Correct Answer:
B. Group by product family > Filter to show only Closed Won opportunities >Sum the total number sold
Explanation

To create a report showing top-selling product families by quantity, the data must be organized correctly. The report should be grouped by "Product Family" to aggregate sales data for each family. It must then be filtered to include only "Closed Won" opportunities, as these represent actual sales. Finally, the quantity field should be summarized (summed) to get the total number of products sold within each family, fulfilling the manager's request.

Why Incorrect

A. Grouping by opportunity stage is incorrect; the primary grouping should be by product family. This approach would not show sales aggregated by product type.
C. Grouping by "active products" is not the same as "product family," and filtering by "this year" was not a specified requirement in the prompt.

References

1. Salesforce. (2024). Build a Report in Lightning Experience. Salesforce Help. Retrieved from https://help.salesforce.com/s/articleView?id=sf.reportsbuilderlightning.htm&type=5. This guide details the steps for building a report, including adding groups (Section: "Group Your Report Data") and setting filters (Section: "Filter Your Report Data").

2. Trailhead. (n.d.). Create Reports and Dashboards for Sales and Marketing Managers. Salesforce. Retrieved from https://trailhead.salesforce.com/content/learn/projects/create-reports-and-dashboards-for-sales-and-marketing-managers/create-a-report-for-the-sales-manager. This project provides a practical example of creating a sales report, emphasizing the importance of correct grouping and filtering to answer specific business questions.

Scroll to Top