How to Limit a List to the Top Values in an Excel 2007 PivotTable

After you have created a PivotTable report in the Microsoft Office Excel 2007 spreadsheet application, you can sort the data that is displayed. For example, you can limit the list of your PivotTable report to only display the top values. You also can specify the criteria for the top values to meet your preferences. The top values also can be limited to the 10 largest values from your report, and you can also choose to display the bottom values.

Instructions

1. Open the Microsoft Excel 2007 application that contains the PivotTable that you want to edit.

2. Click on the arrow next to the "Axis Fields (Categories)" field from within your PivotTable chart.

3. Move your cursor over the "Value Filters" option and then click on the "Top 10" option. The Top 10 dialog box will then appear.

4. Click on the "Top" option from the left box. Select the values that you want to sort into the top 10 list by clicking on the "Items", "Sum" or "Percent" option.

5. Select a field from the drop-down list in the box to the right and then click on the "OK" button. Your list will then be limited to the top-10 values you specified.

References

• Microsoft Office: Filter Data in a PivotTable or PivotChart Report
• Microsoft Office: PivotTable Options