» Displaying the Top/Bottom Number of Items
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
1. Select a cell in a row field and press Alt+P to display PivotTable shortcut menu from the PivotTable toolbar (if the PivotTable toolbar is not visible, see the Note in Tip #299).
2. Select Sort and Top 10 (when using Excel 2002 or Excel 2003).
OR
Right-click, and then select Field Settings from the shortcut menu.
3. Click Advanced.
4. In the PivotTable Sort and Top 10 dialog box (when using Excel 2002 & Excel 2003), or in the PivotTable Field Advanced Options dialog box, select the On option button in the Top 10 AutoShow section.
5. Select Top (or Bottom) from the Show dropdown list, and then select the desired display number.
6. In Using Field, select the data field to filter for the Top (or Bottom) items, and then click OK.
Book Store:
Recommended Books:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Microsoft Excel VBA Programming for the Absolute Beginner
- Microsoft Windows XP Inside Out
No comments have been submitted.
