I have a PivotTable listing names and contribution amounts from a dataset. My source data contains some names that I wanted to exclude so I have filtered those out directly from the "PivotTable Fields" pane (not the PivotTable itself). I'd like to be able to see a quick reference list of the names that I excluded from my PivotTable, however, there are a LOT of names in the filtering list. Is there a way to add a chart/key/list of these filtered out names anywhere on my sheet?
Bookmarks