ExamGecko
Question list
Search
Search

List of questions

Search

Question 10 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Find out the percentage of total sales in all categories by customers who have purchased any product which contains the word 'Avery'?

A.
14.52%
Answers
A.
14.52%
B.
16.86%
Answers
B.
16.86%
C.
23.41%
Answers
C.
23.41%
D.
19.65%
Answers
D.
19.65%
Suggested answer: A

Explanation:

Add Product Name filter that contains the word Avery

Drop the Customer ID to the rows, so these are all customers who have purchased the product contains the word Avery.

Select all these Customers and create a group.

Now, right-click on the Customer ID (group) and click on Edit Group

Mark the Include 'Other' Checkbox.

Now, you have two members in your group. First, one of those who purchased any product contains the word Avery, and the other ones are the rest of the customers.

Remove the Product Name from filters.

Drop the Sales to the Text, and right-click on Sales and Select Quick table calculations -> Percent of total.

asked 23/09/2024
Balanavaneethan Nitharsan
29 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first