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 questionsTo 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.
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.
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.
Keep practicing
Take the free SALESFORCE-ASSOCIATE practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SALESFORCE-ASSOCIATE practice questions
- Question 1Get Cloudy Consulting plans to implement Agentforce to enhance their sales team's efficie…
- Question 3What should the account owner at Get Cloudy Consulting use to learn the sum of the amount…
- Question 4Get Cloudy Consulting (GCC) provides consulting services to small and medium-sized busine…
- Question 5A Salesforce associate is asked to share records about a carpool program with users. Whic…
- Question 7A Salesforce associate wants to connect with other Salesforce associates in their local a…
- Question 8A Salesforce associate wants to quickly create an org where they can learn, practice, and…
