+ Reply to Thread
Results 1 to 2 of 2

Advanced filter for Pivot

  1. #1
    Registered User
    Join Date
    07-27-2012
    Location
    kenosha, WI
    MS-Off Ver
    Excel 2003
    Posts
    9

    Advanced filter for Pivot

    Is there a way to do an advanced filter in a pivot. Linked below is a limited sample of what I am doing.

    On sheet 2 is the pivot, what I am trying to do is if I have a list of say 40 different employee ID's I do I filter to only see those without having to manually check each employee id. The file attached is stripped down and only has about 6 for testing purposes. For testing if I only want to see employee id # 555555 and 222222 and 777777
    how would I do that without manually checking each employee if in the filter at the top. The fields on sheet 1 will always be consistent with the header column info.


    The data I am working with is extremely large and I am trying to streamline the process.

    https://drive.google.com/open?id=1o9...zPjAXUomHQH2ie

  2. #2
    Registered User
    Join Date
    02-04-2018
    Location
    Patna, India
    MS-Off Ver
    2010
    Posts
    5

    Re: Advanced filter for Pivot

    I think you should use Slicer separately for each Id.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Advanced filter in Pivot
    By jasmcduffie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-16-2017, 05:06 PM
  2. Replies: 0
    Last Post: 03-06-2017, 03:55 PM
  3. advanced filter - button to re apply advanced filter across multiple sheets
    By motmac87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 11:16 PM
  4. [SOLVED] Return Names From List w/o Advanced Filter or Pivot Table?
    By d_striker in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 12-28-2012, 08:02 PM
  5. Pivot Table - Advanced Filter or Countif in Excel 2007
    By Andjsmith in forum Excel General
    Replies: 1
    Last Post: 07-17-2012, 10:59 AM
  6. advanced filter a range:Advanced Filter function
    By Il Principe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. [SOLVED] Pivot - Advanced filter
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 02-20-2005, 03:06 AM

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