Pivot Filters
 

Hi

We have created a Pivot Table and have found that items that have been input
into the data source were not always input correctly such as; 'dove' AND
'doves'. This means that the entry is appearing twice on the pivot even
though it refers to the same information. Now, when the entry is corrected
(ie doves changed to dove) the entry is still appearing in the filter list -
which obviously displays a static list of entries rather than a refreshed
version of what is actually in the list. Is there any way that these
incorrect entries can be removed from this list or can the list be set up to
display accurate filters?

Regards
Mike

Pivot Filters
 

Hi,

See Debra's page,
http://www.contextures.com/xlPivot04.html

Cheers
Andy

Mike Diamond wrote:
Hi

We have created a Pivot Table and have found that items that have been input
into the data source were not always input correctly such as; 'dove' AND
'doves'. This means that the entry is appearing twice on the pivot even
though it refers to the same information. Now, when the entry is corrected
(ie doves changed to dove) the entry is still appearing in the filter list -
which obviously displays a static list of entries rather than a refreshed
version of what is actually in the list. Is there any way that these
incorrect entries can be removed from this list or can the list be set up to
display accurate filters?

Regards
Mike

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Pivot Filters
 

Thats great Andy, thanks for your help my friend..

"Andy Pope" wrote:

Hi,

See Debra's page,
http://www.contextures.com/xlPivot04.html

Cheers
Andy

Mike Diamond wrote:
Hi

We have created a Pivot Table and have found that items that have been input
into the data source were not always input correctly such as; 'dove' AND
'doves'. This means that the entry is appearing twice on the pivot even
though it refers to the same information. Now, when the entry is corrected
(ie doves changed to dove) the entry is still appearing in the filter list -
which obviously displays a static list of entries rather than a refreshed
version of what is actually in the list. Is there any way that these
incorrect entries can be removed from this list or can the list be set up to
display accurate filters?

Regards
Mike

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info