+ Reply to Thread
Results 1 to 2 of 2

Auto filter and Pivot Table

  1. #1
    Registered User
    Join Date
    05-26-2006
    Posts
    1

    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?

  2. #2
    Debra Dalgleish
    Guest

    Re: Auto filter and Pivot Table

    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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1