Double-click on the Vendor field button
Click the Advanced button
For Top 10 AutoShow, select On
Set the Show to Top 10


ChrisBusch wrote:
For example:

Row Headers are State, then Vendor.
Column Headers are Year.
Cell Value is Sales Amt
Need to display the top 10 vendors by sales amt within each state.

When I use sort and top 10 within the pivot table, i get
top 10 vendors overall sorted within state.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html