I have a pivot table in which some of the columns of data change frequently. When I look at the drop down it has values that are not in the detail data I am pulling from but were in there are some point. I do not want to recreate the pivot and was wondering is there a way to remove this data. i.e. under aliases when we use the drop down we have jacks,smiths, andersons and hendersons, but the smiths are not in the detail data.
Thanks
Thanks