Is there a way to copy and paste a certain list of values into the pivot tab slicer or filter? For example, the pivot table returns result for 1000 account codes, but I only want to see the results for 200 of those 1000. I have the list of the 200 account codes that I want to see results for. I want to be able to insert the custom list of 200 into the slicer or any other filtering option. Is this feasible within Excel's pivot tables? I am able to this in Tableau and Power BI for another set data set.
I don't want to have to select the 200 codes individually so I appreciate any suggestions.
P.S. I am generating the pivot table from an external data (using the Analysis Services).
I don't want to have to select the 200 codes individually so I appreciate any suggestions.
P.S. I am generating the pivot table from an external data (using the Analysis Services).