I have a pivot built off a large dataset.
On the pivot, each column has the drop-down selector to filter the values.
If I reduce the source data, deleting certain rows... e.g. remove all rows contain certain states say CA, TX, PA... then when I refresh the pivot, I would expect the drop down filter not to display CA/PA/TX. But it continues to display these as valid items to filter on, even though they are not.
Obviously I have checked the source data, and I have used the dropdown filter on these and it selects no data in the pivot, so how can I get the now non-valid values to disappear off the filter dropdown?
TIA.
Ralph in Auckland
Bookmarks