Auto filter and Pivot Table

[RandyLewisKemp]

Is it possible to auto filter data, and use it as input to a Pivot
table? When I run a test where I first auto filter, I initially had
20000 rows, and the auto filter reduced it to 12000 rows. But when I
go to crearte a pivot table on the filtered data, I am back to a total
record count of 20000. Am I combining apples and oranges? If so, is
there a way to filter data, before it gets inputed to a Pivot table?

 

[Debra Dalgleish]

Instead of an AutoFilter, you could use an Advanced Filter, and extract
the records to another range. Base the pivot table on the new list.
There are Advanced Filter instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html