Page 723 - Excel 2013 All-in-One For Dummies

Using the PowerPivot and Power View Add-Ins 705
Figure 2-19 shows a prime example of the kind of visual report that you might want to create with the Power View add-in. The map on this Power View worksheet shows the total sales geographically with different sized circles that represent the relative sales in that region. When you position the mouse or Touch pointer on one of the circles in this Power View report, Excel displays a text box containing the name of the region followed by the total amount of its sales.
To create this Power View report, you simply select the SalesAmount field
in the FactSales data table as well as the RegionCountryName field in the related Geography data table. (These two tables are related in a one-to-many relationship using a GeographyKey field that is primary in Geography data table and foreign in the FactSales data table.)
After selecting these two fields in the Power View Fields task pane of the Power View worksheet by clicking their field names after expanding their tables in the list, I created the visual report shown in Figure 2-19 simply by clicking somewhere in the table to select it and then clicking the Map option in the Switch Visualization group of the Design tab and then replacing the generic, Click Here to Add a Title, with the Aggregated Sales by Country label shown there.
Book VII Chapter 2
Generating Pivot Tables