Debra,
I have a similar request.
I have a colum that has gross sales in a pivot table along with other data.

I want to do a query (or custome lookup) if the gross sales is greater
then 50,000.00 and less then 100,000
then i only want those records to appear in the pivot table.
Is this possible and how,

Thanks
Dean Castaldo
Giles Chemical Corp



"Debra Dalgleish" wrote:

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