| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 pivot table source table | Excel Discussion (Misc queries) | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| Apply a formula as a pivot table calc or suggestion | Excel Worksheet Functions | |||
| Transforming pivot table back to the source table | Excel Worksheet Functions | |||
| Can I set a filter on the source data for a pivot table | Excel Discussion (Misc queries) | |||
Threaded Mode
