ExamGecko
Question list
Search
Search

List of questions

Search

Question 62 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. What is the total profit earned by all the cities in Wake County, North Carolina from the year 2012 to 2014?

A.
$527
Answers
A.
$527
B.
$403
Answers
B.
$403
C.
$427
Answers
C.
$427
D.
$503
Answers
D.
$503
Suggested answer: B

Explanation:

Drop the State to the View. And drop the Country to the Filter Shelf and Select the United States.

Drop the City to the view, and add the State to the Filter shelf and select North Carolina.

Also, drop the Order Date to the Filters and select year 2012, 2013, 2014

Now, drop the Profit field to the tooltip. As of now, your view should look like this:

Now, we have to find the total profit earned by all the cities in Wake County.

Drop the City field to the view and drop the state to the Filters shelf and Select North Carolina only.

To show the County go to the Map->Map Layers.

Check County Names and County Borders.

the total profit earned by all the cities in Wake County is $403.

asked 23/09/2024
Joice Lira
30 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first