Re: Filter Pivot Table?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 02/09/04

Next message: Debra Dalgleish: "Re: Leader lines on charts"
Previous message: Yo: "Filter Pivot Table?"
In reply to: Yo: "Filter Pivot Table?"
Next in thread: Yo: "Re: Filter Pivot Table?"
Reply: Yo: "Re: Filter Pivot Table?"
Messages sorted by: [ date ] [ thread ]

Date: Mon, 09 Feb 2004 17:38:16 -0500

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 ***, 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

Next message: Debra Dalgleish: "Re: Leader lines on charts"
Previous message: Yo: "Filter Pivot Table?"
In reply to: Yo: "Filter Pivot Table?"
Next in thread: Yo: "Re: Filter Pivot Table?"
Reply: Yo: "Re: Filter Pivot Table?"
Messages sorted by: [ date ] [ thread ]