| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Suggested new functionalities for Filters, Pivots and other issues | Excel Discussion (Misc queries) | |||
| Suggested new functionalities for Filters, Pivots and other issues | Excel Discussion (Misc queries) | |||
| Selecting multiple filters in a pivot table | Excel Discussion (Misc queries) | |||
| Using Pivot Charts, how to hide field values in second level filters? | Excel Discussion (Misc queries) | |||
| Pivot Charts, hiding field values in second level filters? | Charts and Charting in Excel | |||
Linear Mode
