Which genre sells the most?

To help determine next year's budget, you are asked to create a visualization to determine which genre sells the

most to our customers in Europe and Asia.

$1.$ Drag the Genre dimension to Rows.

$2.$ Drag the Quantity measure to Columns. Notice this will automatically aggregate quantity using SUM.

$3.$ Drag the Genre dimension to Color. Remember that you have to use color with caution, but in our case, we will

use this color to relate to another worksheet we'll build in the next exercises.

$4.$ Click on the Descending bars icon on the toolbar

$5.$ Click on the $"$T$"$ icon on the toolbar to turn on labels

$6.$ Drag the Region dimension to the Filters shelf. Choose Europe and Asia. Click OK$.$

$7.$ Right click the Region pill in the Filters shelf to show the dropdown.

Choose Apply to Worksheets $>$ All Using This Data Source.

$8.$ Right click the Region pill in the Filters shelf to show the dropdown.

Select "Show Filter".

Notice at the top right, the display of another card that has all the Region values with checkboxes right beside

them. Your users can use this to interact with this worksheet.

$9.$ Right click on the bar of the top selling genre, and choose Annotate $>$ Mark.

Type the following in the Annotation editor. For anything in angled bracket, use the "Insert" dropdown menu to

select the actual fields.

Top Selling Genre: $<$ Genre$>$

Quantity Sold: $<$ SUM$($Quantity$)>$

Click OK when you are done

$9.$ Adjust the location of the mark annotation so it's visible in the view.