Exclude data from Pivot Table based on filter?
 

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.

Exclude data from Pivot Table based on filter?
 

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.
--
Thanks,
Shane Devenshire


"Eric" wrote:

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.

Exclude data from Pivot Table based on filter?
 

Shane - Thanks for your help.

"ShaneDevenshire" wrote:

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.
--
Thanks,
Shane Devenshire


"Eric" wrote:

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.