XL98: How to Use the PivotTable AutoShow FeatureLast reviewed: March 19, 1998Article ID: Q182737 |
The information in this article applies to:
SUMMARYIn Microsoft Excel 98, you can use a new PivotTable feature called AutoShow to quickly analyze a large set of data to find specific results. For example, you can use the AutoShow feature to find the top ten salespeople per region based on sales figures.
MORE INFORMATIONA PivotTable is an interactive table that summarizes and analyzes data from existing lists and tables. In earlier versions of Microsoft Excel, it is possible to sort by PivotTable data fields and to hide items from a row or column field. It is also possible to hide PivotTable field items. However, there is no feature that automatically displays a subset of PivotTable field data that is updated as the PivotTable is updated. Microsoft Excel 98 allows you to easily display a subset of the PivotTable data that is recalculated automatically when the PivotTable is updated. This feature is called the AutoShow feature. The subset that is displayed can be the largest (top) <n> data values or the smallest (bottom) <n> value fields, where <n> is a number that you specify. For example, you can have Microsoft Excel display the top ten students per teacher based on test grades or the bottom three golfers per golf course based on golf scores. Each time the PivotTable is updated with new data, Microsoft Excel recalculates and displays the top or bottom items. You can access the following two basic AutoShow settings in the "PivotTable Field Advanced Options" dialog box: Manual or Automatic. If you select Automatic, you can specify whether to show the bottom or top items, and you can specify the number of items to show for the field. Also, when you select Automatic, you can specify the data field to use when you display the top or bottom items. NOTE: When you select a field and use the AutoShow feature, the field name in the PivotTable is formatted in blue to indicate the state of the field.
Using AutoShow in an Existing PivotTableTo use AutoShow, follow these steps:
Using AutoShow in an New PivotTableTo use AutoShow, follow these steps:
ExampleTo use AutoShow to display the top three student grades, follow these steps:
REFERENCESFor more information about Autoshow, click the Index tab in Microsoft Excel Help Contents and Index, type the following text:
pivottables, displaying dataand then double-click the selected text to go to the "Control the amount of detail that appears in a PivotTable" topic. Then, click "Display the top or bottom items for a PivotTable field.
|
Additional query words: XL98 pivot table auto show refresh refreshed
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |