Apply Filter to source of Pivot Table

  • Thread starter Thread starter frankie.lau
  • Start date Start date
F

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
 
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.
 
Thanks Dave, your suggestion is helpful.
Dave said:
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.

:-
Click to expand...
 
Back
Top