• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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, the lowest, and so on. You can set top and bottom limits for values in a pivot table as well.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint