Last updated: July 18, 2008 11:47 PM
![]()
Excel -- Pivot Tables -- Field Settings
- Manually Hide or Show Subtotals
- Programmatically Hide Subtotals
- Show Items with No Data
- Show Top Items Only
- Sort All Fields in Ascending Order
Download the zipped sample file
Show Top Items Only
Instead of showing all the items in a field, you can restrict the Pivot Table to show only the top (or bottom) items.