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?


--
RandyLewisKemp
------------------------------------------------------------------------
RandyLewisKemp's Profile: http://www.excelforum.com/member.php...o&userid=34846
View this thread: http://www.excelforum.com/showthread...hreadid=545909

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

RandyLewisKemp wrote:
> 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
Contextures
http://www.contextures.com/tiptech.html