C h a p t e r 9 : A n a l y s i s w i t h E x c e l 2 0 0 7 309
Not only are subtotals shown by default, but the PivotTable also shows grand
totals by default. These appear at the bottom and right of the PivotTable but can
be turned off as part of setting properties for the entire PivotTable. Right-clicking
anywhere in the PivotTable and then choosing PivotTable Options opens the
PivotTable Options dialog box. There are many properties that can be altered via
this dialog box, but grand totals are found on the Totals & Filters tab. Here, two
check boxes control the row and column grand totals so they can be turned on and
off independently. Figure 9-12 shows this dialog box with both the row and column
grand totals turned off. The PivotTable reflects these changes, and also moves the
subtotals to the bottom of the group as described in the previous paragraph.
Conditional Formatting and KPIs
Excel 2007 includes additional formatting capabilities that allow end users to apply
conditional formatting to their Excel spreadsheets. One such feature is conditional
Figure 9-12 Subtotals can be turned off or moved to the bottom of the group. Grand totals
can be turned off for either rows or columns or both.
310 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
formatting, which is not limited to PivotTables but can be used anywhere in Excel.
There are several different kinds of conditional formatting available, and the choices
can be found on the Home ribbon by clicking on the Conditional Formatting button.
Pages:
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398