Microsoft Office Tutorials and References
In Depth Information
Your Very Own Top 10 List
Once this option is selected (though this is the de fa ul t se l e cti on ) y ou ca n cl i ck on a n y supe r
category (that is, data in the first Row Labels column) entry, release the mouse, and then rest the
mouse again over the lower cell border of that entry. When you see a four-sided arrow, click and drag
the entry to any other position in the column. You can do the same with data in the Column Label area;
only here, you click on the right border of the entry you wish to move, and drag it horizontally to any
position in the Column Label area.
Your Very Own Top 10 List
Now here’s yet another very useful filtering technique of sorts. For the sake of simplicity, let’s
scale down our pivot report so that Salesperson occupies the Row Labels area, and Sum of Order
Amount holds down the Values area. If you right-click anywhere in the Row Labels area and click the
Filter Top 10… , you’ll see (Figure 8–38):
Figure 8–38. The Top 10 dialog box
Now because we have only nine salespersons, a Top 10 list just won’t do. If you either type 5 to
replace the number 10 or click the down arrow until you arrive at that number and click OK, you’ll see
(Figure 8–39):
Figure 8–39. Quite a quintet-the top five salespersons, by dollars generated
Now you’re identified the five highest sales achievers. You could also substitute Bottom for Top in
the leftmost field in the dialog box, as well as Percent for Items . Thus you could determine the either the
top ten, or the top ten percent, of test scorers in a class of 500 students, for example. To turn off this
feature, right-click again in the Row Table area and click the Filter Clear Filter From ... comman d. Al l
the records return. Bet Letterman can’t do any of this.
Search JabSto ::

Custom Search