• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Analyzing Data with PivotTab... > Showing the Top or Bottom Items in a...

Showing the Top or Bottom Items in a Field

The AutoShow feature lets you display only the top or bottom n items in a field, based on values in the data area of your table. To use AutoShow, select the field you're interested in, and then click the Field Settings button on the PivotTable toolbar. (Alternatively, choose PivotTable, Field Settings.) In the PivotTable Field dialog box, click Advanced to display the PivotTable Field Advanced Options dialog box, shown in Figure 30-16. Figure 30-17 shows an example of a PivotTable that uses AutoShow. To match this, rearrange the table so that the Quarter field appears on the row axis and the Channel field is on the column axis. Then apply AutoShow to the Quarter field, choosing to display only the top two quarters based on Sum Of Sales.

Figure 30-17. You can use AutoShow to display only the top two quarters for each CatalogNo item, based on Sum Of Sales.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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