G
Guest
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
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