Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Question
Can the pivot table feature be set-up to only apply to unfiltered data - for
example if my worksheet has a column filtered. Thank you in advance ? |
#2
|
|||
|
|||
No, the pivot table uses all the source data, not the filtered table.
You could use an Advanced Filter to extract some of the data to a different worksheet, then base the pivot table on that. carl wrote: Can the pivot table feature be set-up to only apply to unfiltered data - for example if my worksheet has a column filtered. Thank you in advance ? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
hi carl,
the pivot tables look at all the data in its source range. however, if you can use the filtered field in the pivot table itself, then you can filter it from the table view. if it isn't used in the table itself, you can use it in the page field. if you are already using the page field, then you may have to copy the filtered data to a new sheet, etc. :( "carl" wrote: Can the pivot table feature be set-up to only apply to unfiltered data - for example if my worksheet has a column filtered. Thank you in advance ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
pivot table question, sum fields? | Excel Worksheet Functions |