ExamGecko
Question list
Search
Search

Question 10 - TDS-C01 discussion

Report
Export

Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

A.
Tom Ashbrook
Answers
A.
Tom Ashbrook
B.
Sanjit Engle
Answers
B.
Sanjit Engle
C.
Penelope Sewall
Answers
C.
Penelope Sewall
D.
Tamara Chand
Answers
D.
Tamara Chand
Suggested answer: C

Explanation:

As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000

1) Right click on customer name --> Create --> Set

2) Let's Name the Set - Customer>30k ( you can name it anything you want :) )

Select USE ALL, and then move to the CONDITION TAB:

3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK

4) You should now have a new Set in the Data Pane as follows:

5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.

6) Click on the Show Mark Labels, and Sort ascending icons as shown:

7) Voila! We have our answer:

asked 23/09/2024
Hoang Son
47 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first