Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Pivot Table Properties

Pivot tables come with an array of features that either enhance your analytical power or simply make life easier and more pleasant. On the mundane side, you can change fonts and supply captions. On the much more interesting analytical side, you can create group items and filter for top (or bottom) values. Most of the fine-tuning is performed in the Properties dialog box, which is available from the context (shortcut or right-click) menus. The properties in the dialog box, as with those in the property sheet in a form, depend entirely on which element of the table you select.

Using the Top Values Property

As you might recall from Chapter 8, “Queries,” you use the Top Values property to show the best, the worst, the highest, ...