+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Filters - 1st filter also filters 2nd filter

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Office 365 MSO (16.0.10730.20264) 32-bit
    Posts
    160

    Pivot Table Filters - 1st filter also filters 2nd filter

    Hi.

    I have a pivot table and chart based on data. I have multiple pivot filters. 1st being Cost Center, 2nd being People's names (Every person is associated to only one cost center - many people in each cost center - many cost centers). When I set the pivot table filter for cost center, I would like the 2nd filter to only show people's names in that cost center, not all names in all cost centers which is what it shows. Any way to do that?

    Thanks
    Steve
    Harrisburg, PA

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: Pivot Table Filters - 1st filter also filters 2nd filter

    you could add a filter over the top of the pivot table.
    (I.e. filter from the data menu)

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Pivot Table Filters - 1st filter also filters 2nd filter

    Hi Steve,

    If you use Slicers to filter your fields, they will indicate visually which data is no longer applicable based on other filters in use. The dropdown filters do not have such a capability.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. How to filter a field in pivot table using two filters
    By Bluemini in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-27-2015, 12:41 AM
  2. Replies: 1
    Last Post: 07-16-2015, 05:46 AM
  3. Replies: 4
    Last Post: 04-29-2015, 02:00 PM
  4. Filter report filters based upon previous report filters!!??
    By jackie_m in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2015, 05:17 AM
  5. Filter Feature has Text Filters, but I want number filter
    By 6string in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 06-09-2014, 02:57 PM
  6. [SOLVED] Tables and Filters - How to remove filter on table without removing little arrows?
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2014, 11:48 AM
  7. Controlling multiple pivot table filters with one filter.
    By adoepker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2011, 03:41 PM

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