Data filter in Pivot table

Hi,

I have a pivot table with data of 2 numeric columns. I want the data to filtered on one of the columns to greater than 100. Just like autofilter->custom->Greater than 100.

How do we do this in pivot table.

Please help.

Thanks
Anand

use sumproduct instead of pivot table, building your criteria of >100 into that.

=sumproduct(($a$1:$a$10 >100)*1)