With the Field List visible, it??™s now possible to create a report by simply dragging
and dropping or by clicking the check boxes beside the items in the Field List.
Assume that the user scrolls down to the Sales Summary measure group and selects
Figure 9-5 Adding a PivotTable to a spreadsheet shows an empty PivotTable and opens
the Field List along the right side of the page.
302 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
the Sales Amount measure. Clicking the check box next to this measure will add it to
the Values box in the Areas section. The value will now appear in the grid as the total
sales amount for all time, all products, all customers, and so forth; it will be the total
sales amount in the cube, which is just under $110 million.
Scrolling down to the Date dimension, expanding Calendar, and selecting
Date.Calendar adds that to the Column Labels box, while moving to the Product
dimension and selecting Product Model Categories adds the Product Model
Categories to the Row Labels box. In addition, the PivotTable updates to show the
members on the rows and columns, as expected. Totals are also turned on for both
rows and columns automatically. Figure 9-6 shows what this simple report looks
like, along with the layout shown in the Field List.
There are a number of things to notice about the PivotTable in Figure 9-6. First,
the upper left-hand corner is labeled Sales Amount.
Pages:
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391