Hi all,

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

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

Thanks,
Frankie

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

Then I use a formula to that column:

=if(a210000,"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" wrote:

Hi all,

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

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

Thanks,
Frankie

--
frankie.lau

--

Dave Peterson

Thanks Dave, your suggestion is helpful.