Which customer had the LEAST sales in this set?

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
B . Sanjit Engle
C . Penelope Sewall
D . Tamara Chand

View Answer

Answer: C

Explanation:

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: