Filter Pivot Table?

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.

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 wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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


"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:40280BD8.9040605@contexturesXSPAM.com...
> 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 wrote:
> > 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
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>