Auto filter and Pivot Table



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?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Help! 1
Pivot Table Filter values 5
Export Pivot table 1
Update Filter List AFTER Filter Applied 3
pivot table filters 1
Filter for Pivot Table 5
Pivot table report invalid 0
Filter question 2