Apply Filter to source of Pivot Table

[frankie.lau]

Hi all,

Would like to know is it possible to apply filter on source data o
Pivot table in Excel 2007? My scenario as below:

The source data contains sales figures and we'd like to have a Pivo
table to sum & count rows with sales amount > 10K. We tried to se
sales amount to the Report Filter but we have manually mark th
selection.

Thanks,
Franki

 

[Dave Peterson]

I add another column to the original data source (hide/show is the header).

Then I use a formula to that column:

=if(a2>10000,"Show","hide")
(and drag down)

Then I use this field as a page item in my pivottable.

I change the formula and refresh the table when I need a different view of the
data.

 

[frankie.lau]

Thanks Dave, your suggestion is helpful.

I add another column to the original data source (hide/show is th
header).

Then I use a formula to that column:

=if(a2>10000,"Show","hide")
(and drag down)

Then I use this field as a page item in my pivottable.

I change the formula and refresh the table when I need a different vie
of the
data.

:-