View Single Post
  #1   Report Post  
frankie.lau frankie.lau is offline
Junior Member
 
Posts: 2
Default 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