Dropping
down either list reveals a series of options, as shown in Figure 9-7. There are two
sort options at the top, and they allow you to sort either in ascending or descending
order. A third option, labeled More Sort Options, opens a dialog box that allows
users to sort in other ways, including manually, by simply dragging and dropping the
members in the preferred order.
The drop-down list also allows users to apply label filters and value filters to
the data. Label filters restrict the data based on the label that is being shown. For
example, Figure 9-7 shows Accessories, Bikes, Clothing, and Components for the
row labels. Clicking on Label Filters and choosing Begins With opens a simple
dialog box that asks for a value on which to filter the data. Putting in just the letter
c and then clicking OK immediately reduces the values in the list to just Clothing
and Components. Begins With is just one of the many options for filtering data, with
others including Equals, Does Not Equal, Contains, Greater Than, Between, and so
on. The Column Labels drop-down list provides the same options as for Row Labels,
although in this case the column contains dates. This means that the Label Filters are
changed to Date Filters, and that filter methods include Last Month, Next Month,
This Month, and similar values for days, weeks, and quarters.
Value Filters limit the items in the rows or columns based on the values of the
particular measure. For example, dropping down the list for Row Labels, selecting
Value Filters, choosing Greater Than, and entering a value of 90,000,000 will restrict
the members on the rows to just Bikes, since it is the only one with a Sales Amount
of greater than $90,000,000.
Pages:
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393