Filter Pivot Table?

  • Thread starter Thread starter Yo
  • Start date Start date
Y

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.
 
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'
 
Back
Top