5
Is there a way to run a pivot table on an Excel sheet that already has columns filtered?
Thus far, I've had to manually copy and paste the sheet into another sheet and then run a filter on that.
Is there an alternative way to do this sort of thing?
1I just understood what you actually meant, and no, I don't think that's possible to directly create a pivottable on the filtered contents of a worksheet. – Jerry – 2013-05-28T20:54:09.287