I attached a set of data. I sorted it into "Black". (In practice, there would be many more columns that would have been sorted/filtered out).
Next I want to create a pivot table from the sorted data. Is there any way for me to do this without copying and pasting the sorted/filtered data onto another tab, then creating a data table from that?
What I did here was create a pivot table from the sorted/filtered data. However, the pivot table still shows that it is unsorted. Therefore, I would have to pivot it again.
In this instance, I just want to show the "Black" division in the pivot table. However, I don't want to go through all the pivoting again. (in reality there would be many). Is there any simpler way to do this? Thanks for your help.
Bookmarks