Pivot Filters

M

Mike Diamond

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dropdown depending on second dropdown / filter problem 0
Excel doesn't filter entire list. 1
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
VLOOKUP a Pivot Table Filter 0
date filter in a pivot table 1
missing data w/ advanced filter 6
Pivot table charting 3
Refreshing some Pivots Tables makes Excel stop or crash 0

Top