The Row Labels and Column Labels drop-down list boxes can be toggled on and
off using the Field Headers button on the Options ribbon. This helps clean up the
report a bit, but also hides the easiest way to perform sorting and filtering options. An
alternative way to reach the sorting and filtering options is to click the down arrow
that appears to the right of hierarchies in the Field List. Figure 9-8 shows this option
highlighted and the resulting menu for the Product Model Categories dimension.
There is another way to add filtering to a report, but this filtering works like the
parameters on Reporting Services and ProClarity, creating a drop-down box that
allows users to make selections to perform analysis. For example, users might want
to easily filter by Sales Territory. Scrolling to the Sales Territory dimension in the
Field List and then choosing the Sales Territory hierarchy by clicking the check
box next to it will add it to the Row Labels box by default. The user can drag the
hierarchy from the Fields section to the Report Filter box in the Areas section, or
if it??™s already in another box in the Areas section, it can be dragged from that box
into the Report Filter box. Adding the Sales Territory hierarchy to the Report Filter
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 305
box adds a drop-down list at the top of the report that includes the members of the
various levels of the hierarchy in a tree view format. Figure 9-9 shows what the filter
looks like by default.
Pages:
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394