QUESTION: 45 Exam Topic: 2, Exam Pool B

Which of the following are valid calculations?

MAX(SUM(Profit), (Sales))
SUM([Profit]) * SUM([Quantity])
SUM([Profit]) * 1000
SUM([Profit]) * [Quantity]

Answer(s): B,C

Explanation:

You cannot mix the aggregated and non-aggregated calculations. MAX(SUM(Profit), (Sales)) -> Profit is aggregated but Sales is not. SUM([Profit]) * [Quantity] -> Profit is aggregated but Quantity is not. You can multiply the aggregated/non-aggregated fields with constant. That's why SUM([Profit]) * 1000, is correct.
SUM([Profit]) * SUM([Quantity]) - Both are aggregated

Reveal Solution Next Question

QUESTION: 46 Exam Topic: 2, Exam Pool B

View Related Case Study

Connect to the "Global Superstore" data source and use the Orders table. Find out the group of states(in the US) having the highest sales in 2013?

New York, Massachusetts, Rhode Island
California, Idaho, Nevada
Texas, New Mexico, Colorado
North Carolina, South Carolina, Virginia

Answer(s): B

Explanation:

Drop the State field to a view, you will get >1k unknown. Drop the Country to the Filters Shelf and Select the United States, all unknowns should be gone. Also, drop the Order Date to the Filters Shelf and choose Years as:

Check for the Year 2013.
Drop the Sales field to the Label in the Marks card, your view should look like this:

Now use the Lasso Selection tool from the Map tools:

And create the group of states as per our answer options. Example - for New York, Massachusetts, Rhode Island, Similarly, do for other 3 options as well.

Duplicate this worksheet and remove the Latitude and Longitude from the view and drop this new dimension of groups to the view. California, Idaho, Nevada is the right answer.

Reveal Solution Next Question

QUESTION: 47 Exam Topic: 2, Exam Pool B

View Related Case Study

I have a view that shows the top 5 countries as per the sales, I also have a region filter, but most of the region filter values we don't need. For example - We don't have any country which is part of the Eastern Europe region. So we want to hide all those regions which are not valid here. How to do it? Larger image

You will select Exclude Values in a filter card options
You will select Only Relevant Values in a filter card options
You will select Format filter and Set Control in a filter card options
You will select Wild card match in a filter card options

Answer(s): B

Explanation:

Go to Filter card options, and Select Only Relevant values

Reveal Solution Next Question

QUESTION: 48 Exam Topic: 2, Exam Pool B

View Related Case Study

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?

$527
$403
$427
$503

Answer(s): 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.