A Pivot table has a Top 10 feature that you can use to show only the top
values.

Or, you could add a column to the source data, and use the SUMIF or
SUMPRODUCT function to calculate if the total for an item is over your
set limit. Then, add that field to the page area, and use it as a filter.

Angus wrote:
I want to show the data greater than a specific number, say 10, in a pivot
table, like what can be done by autofilter in raw data.

I know I can use "autofilter" at pivot table, but it doesn't apply to the
new pivot tables created by "show pages". How to keep showing data greater
than 10 at the new pivot tables created by "show pages".


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