Filter Pivot Table?

[Yo]

I have a page field with currency between 100,000 and 1,500,000.
I would like to be able to filter the list to show values > x, where x is a
number I determine after the pivot table is created. It appears that the
page field is unable to accomodate me. Is there another way to accomplish
this?
Thanks in advance,
Yo.

 

[Debra Dalgleish]

You could add a field to the data source, to calculate if each record
meets the criteria. For example, if units sold is in column E, create a
field with the heading 'Show', and enter the following formula:

=E2>=Pivot!$J$1

On the Pivot sheet, in cell J1, enter the x value, then refresh the
pivot table.

Add the 'Show' field to the PivotTable page area, and from the dropdown
list, select 'TRUE'

 

[Yo]

Thanks... Also, that was a great guess about the column the units sold was
in.
Yo.