+ Reply to Thread
Results 1 to 2 of 2

Show items in pivot table filter's drop-down list based on other filters of the same table

  1. #1
    Registered User
    Join Date
    07-15-2015
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    1

    Show items in pivot table filter's drop-down list based on other filters of the same table

    Hello all,

    I am having some trouble with items in the drop down list of filters of a pivot table.

    For example, I have 3 filters for my pivot table.

    Filter 1: Region (e.g. North, South, East, West)
    Filter 2: Neighborhood (i.e. Names of neighborhoods)
    Filter 3: Street Names

    After selecting a particular Region (e.g. South) and Neighborhood (e.g. Queenstown), the drop-down list in Filter 3 shows all Street Names in the entire database.

    However, it is quite an overwhelmingly long list to scroll through to select the Street Name(s) that I am interested in.

    Is there a way to show only the Street Names of the selected Region and Neighborhood in the drop-down list in Filter 3? Following which, I can select multiple Street Names of interest from a shorter and filtered list.

    I know that it is possible with slicers but first, they are slightly bulky on the page and takes up quite a lot of space and second, I can only select 1 Street Name at a time.

    Thanks!

  2. #2
    Registered User
    Join Date
    07-15-2015
    Location
    South East England
    MS-Off Ver
    2010 & 2013
    Posts
    72

    Re: Show items in pivot table filter's drop-down list based on other filters of the same t

    If you hold Ctrl you can select multiple Slicers

+ 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. [SOLVED] filter pivot table for items in a list in another workbook if found
    By simarui in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2015, 05:35 PM
  2. Pivot Table Drop Down List (filters)
    By ndreid in forum Excel General
    Replies: 2
    Last Post: 08-22-2012, 01:52 PM
  3. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  4. Replies: 0
    Last Post: 08-07-2010, 04:13 AM
  5. Pivot table filter data field to show items with count more than n
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2010, 07:36 PM
  6. Hide/show specific Pivot Table Items based on multiple criteria
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2009, 05:15 PM
  7. Replies: 3
    Last Post: 03-16-2005, 01: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