Specifications

196 CHAPTER 10 Self-Service Analysis with PowerPivot
You can use the Hide and Unhide button on the Design tab (shown in Figure 10-4) to control
the appearance of a column in the PowerPivot window and also in the PivotTable Field List. For
example, you might choose to display a column in the PowerPivot window, but hide that column
in the PivotTable window because you want to use it in a formula for a calculated column.
PowerPivot Reports
A PowerPivot report is an Excel worksheet that presents your PowerPivot data in a summa-
rized form by using at least one PivotTable or PivotChart. You can convert a PivotTable to a
collection of cube function formulas if you prefer a free-form layout of your PowerPivot data.
Regardless of which layout you choose for the report, you can add slicers to support interac-
tive ltering.
PivotTables
You create a report by selecting a layout template from the PivotTable menu (available from
the PivotTable button on the PowerPivot ribbon, as shown in Figure 10-7) and specifying a
target worksheet in the Excel workbook. You can create a layout independently of the avail-
able templates by selecting Single PivotTable or Single PivotChart as many times as you need
and targeting a different location on the same worksheet for each object.
FIGURE 10-7 Report layout templates
NOTE The standard Excel ribbon also includes buttons for building a PivotTable or
PivotChart, but you must use the buttons on the PowerPivot ribbon when you want to use
PowerPivot data.
Assume that you select the Chart And Table (Horizontal) template. Placeholders for the
chart and table appear on the worksheet, and a new worksheet appears in the workbook to