E
Eric
Does Excel 2003 offer any option to exclude data from a pivot table, when the
source data is a table that has been filtered?
Thanks.
source data is a table that has been filtered?
Thanks.
S
ShaneDevenshire
Hi,
If you are asking - if the source of a pivot table has an auto filter (or
advance filter), can I turn off the display of those items in the pivot
table? The answer is yes/no.
No - there is no built in option to say don't display filtered data from the
source.
Yes - you may be able to duplicate the situation
Remember in a pivot table when the Page field is filtered the filtered items
are not displayed by default. So what one needs to do is place the Auto
Filtered fields of the source data into the Page fields. You can then filter
on the page field in the same manner you do in the source data.
A couple of points - 1. if you want the filtered field in the row, or column
area it technically can't be in the page area. In that case create a second
field in the source which is a duplicate of the filtered field and place this
one in the page area.
2. if you want the filter to automatically apply to the pivot table when you
apply it to the data source you should consider VBA. You can code a change
event to handle this.
If you are asking - if the source of a pivot table has an auto filter (or
advance filter), can I turn off the display of those items in the pivot
table? The answer is yes/no.
No - there is no built in option to say don't display filtered data from the
source.
Yes - you may be able to duplicate the situation
Remember in a pivot table when the Page field is filtered the filtered items
are not displayed by default. So what one needs to do is place the Auto
Filtered fields of the source data into the Page fields. You can then filter
on the page field in the same manner you do in the source data.
A couple of points - 1. if you want the filtered field in the row, or column
area it technically can't be in the page area. In that case create a second
field in the source which is a duplicate of the filtered field and place this
one in the page area.
2. if you want the filter to automatically apply to the pivot table when you
apply it to the data source you should consider VBA. You can code a change
event to handle this.
E
Eric
Shane - Thanks for your help.
ShaneDevenshire said:
- Joined
- Mar 27, 2009
- Messages
- 1
- Reaction score
- 0
This is definitely not the right place to post this, but I'm not allowed to be on forums at work and can't spend too much time navigating 
I have an Excel 2003 question (for Windows XP). I have a pivot table with two page filters. If I apply filter 1, filter two remains unchanged.
Example:
Filter 1 - Continent - North America, Asia
Filter 2 - Country - Canada, US, China, India
If I set Filter 1 on North America, Filter 2 still displays all four countries, instead of just showing Canada and US. I believe Excel 2007 has this feature already built in (please correct me if I'm wrong) but how can I attain this feature in Excel 2003?
If the only way is to apply some sort of VBA code, please be very specific, i have never used code before in my life.
Thanks for the help
I have an Excel 2003 question (for Windows XP). I have a pivot table with two page filters. If I apply filter 1, filter two remains unchanged.
Example:
Filter 1 - Continent - North America, Asia
Filter 2 - Country - Canada, US, China, India
If I set Filter 1 on North America, Filter 2 still displays all four countries, instead of just showing Canada and US. I believe Excel 2007 has this feature already built in (please correct me if I'm wrong) but how can I attain this feature in Excel 2003?
If the only way is to apply some sort of VBA code, please be very specific, i have never used code before in my life.
Thanks for the help