ExamGecko
Question list
Search
Search

List of questions

Search

Question 53 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Which of the customer names are in the Top 20 by sales, calculate the profit ratio for these customers and find out who all are in the bottom 5 in profit ratio (within these customers)?

A.
Sean Miller
Answers
A.
Sean Miller
B.
Raymond Buch
Answers
B.
Raymond Buch
C.
Art Ferguson
Answers
C.
Art Ferguson
D.
Bart Watters
Answers
D.
Bart Watters
Suggested answer: A, C

Explanation:

Right Click on the Customer Name -> Create -> Set

Create a calculated field:

Drop the Top 20 by Sales set, Customer Name to Rows.

Drop Sales and Profit Ratio to the view. Format the profit ratio so it will show the percentage.

Sort the Profit.

asked 23/09/2024
Veacheslav Stasiuc
33 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first