Analyzing Cubes using Office Client Components - Professional SQL Server Analysis Services 2005 with MDX - page 805

kind of currency associated with the numbers in the data area. You can select
all the cells in the data area, right-click, select Format Cells, and choose the
currency formatting. Alternatively, you can right-click the cell Internet Sales
Amount, select Format Cells, and select the Currency option in the Category
list; any formatting changes here will be applied to all the cells in the data
area. The formatting options available to any cell in Excel such as alignment,
font, border, and patterns can be applied to the cells in the pivot table.
The Pivot table provides you additional formatting options as shown in Figure
15-28 . To launch the Pivot Table Options page, click the Pivot table drop-
down in the Pivot table toolbar and select Table Options. Most of these op-
tions are self-explanatory. You can enable or disable totals for rows and
columns, center the labels of the members, and show different values in the
report whenever empty cells are retrieved from Analysis Services. We leave
the exercise of exploring these options and the impact on the report as an ex-
ercise for the reader.
Figure 15-28
Excel Pivot tables provide you with various kinds of layouts for your report.
Certain standard templates can be applied to your pivot table report that will
enhance the look and feel for your end users. To select a specific template,