Microsoft Office Tutorials and References
In Depth Information
We can see that this pivot table is very similar to the one used to analyze simple Excel tables,
but it contains some basic differences:
■ In the field list, we have three tables, not just one, as with the classic PivotTable. This
means that you can select attributes and values from all the three imported tables.
Moreover, if you add more tables later, all the PowerPivot tables will be available for
you to select values and attributes.
■ You have two more areas in which to put attributes, the so-called slicers , which we will
Apart from these two differences, the PowerPivot field list looks similar to the standard
PivotTable field list even if, under the hood, it acts as an interface to a very different engine.
Now that you have loaded some tables, you can start analyzing data. Let us start with a basic
analysis: we want to see the total amount sold online versus the same total sold directly. The
SalesOrderHeader contains a True/False column (OnlineOrderFlag) that contains True for orders
placed online and False for orders placed internally; you can select it and place it on the rows.
After that, you can select the LineTotal value from the SalesOrderDetail table, which contains
the total of the single line of an order.
When you have done that, the Excel worksheet looks like Figure 1-10.
FIguRE 1-10 A simple query against a PowerPivot database.