ExamGecko
Question list
Search
Search

List of questions

Search

Question 81 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Create a filter on a product name to find out the top 10 profitable products. Create a crosstab to show these products along with profit value. Now filter this chart to show only the products from the European market. What is the 10th most profitable product?

A.
Belkin Router, USB
Answers
A.
Belkin Router, USB
B.
Cisco Smart Phone, Full Size
Answers
B.
Cisco Smart Phone, Full Size
C.
Nokia Smart Phone, with Caller ID
Answers
C.
Nokia Smart Phone, with Caller ID
D.
Bush Classic Bookcase, Pine
Answers
D.
Bush Classic Bookcase, Pine
Suggested answer: D

Explanation:

Drop the Product Name to the filters and Select Top 10 based on Sum of Profit.

Drop the Product Name to the Rows and Profit to the Text.

Drop the Market to the filter and select the Europe.

Your view will look like this:

Here, you are getting only 9 products.

Add Market filter to the context so that the Product Name dimension filter will be executed after the Market filter.

View:

asked 23/09/2024
Assane SENE
39 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first