Using Power View in Excel 2013 - Business Intelligence in Microsoft SharePoint 2013 - page 133

Creating a table
A table is the simplest form of visualization available in Power View. It is also the starting point for
creating any other type of visualization. To create a table in the view, you can use fields from any data
table in the Power View Fields list, as long as a relationship exists between the data tables contain-
ing the selected fields. After creating the table, you can change the table contents by values in any
column in either ascending or descending order. Additionally, you can move the table to a different
location in the current view.

Adding fields to a table
Let's create a table to display sales amount values by sales territory group.

In the Power View Fields list, expand the Sales Territory table and select the SalesTerritoryGroup
check box.

1.

A table containing a single column of distinct values for the selected field displays in the view,
as shown in Figure 5-7.

FIGURE 5-7 You can select a field to display a column of values in a table.

In the Power View Fields list, expand the Reseller Sales table and select the SalesAmount
check box.

2.

Another column appears in the table, as shown in Figure 5-8. Because SalesAmount is a num-
ber, Power View automatically groups by sales territory group, calculates the sum of sales for
each sales territory group, and adds a total row to the table. Power View performs this auto-
matic aggregation for both decimal and whole number data types. Notice that NA no longer
appears in the table because it has no related sales.

3.

FIGURE 5-8 Power automatically performs grouping of string data and aggregation of numeric data.

In the Power View Fields list, point to SalesAmount, click the arrow that appears to the right
of the field name, and then select Add To Table, as shown in Figure 5-9. As an alternative, you
can also drag SalesAmount into the Fields box in the layout section that appears below the
Power View Fields list.

4.