Apply Filter to source of Pivot Table
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
|