Have 20K line data set that a pivot table has been created from and filtered to desired data ('filtered pivot'). Would like to 'add' additional fields/columns (ex. notes) to the 'filtered pivot' with ability to sort or re-filter the pivot table and the new fields/columns/notes to remain intact. How best can this be accomplished? Thanks!
