+ Reply to Thread
Results 1 to 2 of 2

Filtering Slicers with Slicers ... with Slicers?

  1. #1
    Registered User
    Join Date
    05-24-2019
    Location
    Boise, ID
    MS-Off Ver
    MS Office 2013
    Posts
    5

    Question Filtering Slicers with Slicers ... with Slicers?

    Hey all, Not sure if that title makes sense, but it's what I'm trying to do.


    BLUF -- I'm looking to be able to click a selection in a slicer, and it filters the next slicer, which allows me to filter another slicer, until I reach the end goal.
    I don't even know if its possible.


    So the Concept is this: Work Order Flow Map/Process/Chart

    In order to Close out a Work Order (SAP) -- a specific "System Condition Code" must be used. This is just a single digit alphanumeric.
    When that digit is used, the next selection is limited to specific other digits.
    When one of those digits is selected, the next selection is limited to specific other digits...
    etc...

    Realistically, it would be like F, R, U, S.

    But !! Each of those codes allows for other options...
    Attached Files Attached Files
    Last edited by BOTJ33F; 12-11-2019 at 04:51 PM.

  2. #2
    Registered User
    Join Date
    05-24-2019
    Location
    Boise, ID
    MS-Off Ver
    MS Office 2013
    Posts
    5

    Re: Nest-Filtering Filters in Pivot Tables ...? Uhh ...?

    After more reading, I think my verbiage may be off...

    I … want to filter the output from one slicer (Pivot) against the same "data"

    Please Login or Register  to view this content.
    Example:

    F = Final Inspection
    R = Awaiting Pick Up
    U = Picked Up, must be Closed first
    S = Closed, Technically Completed

    **Each one of these digits has it's own "code description" **

    --- select F
    F can be changed to 1, 2, 3, 5, B, C, E, F, G, I, J, K, R, S, U
    --- select R
    R can be changed to 4, 5, G, M, U
    --- select U
    U can be changed to 5, 8, G, S
    -- select S
    S can be still be changed to 5, 8, R -- but this is the end System Code.

    Notice that between F, R, U, and S -- there are identical digits.

    When I'm using a Slicer -
    I want to select F in the first one, and those selections come up in the second Slicer.
    And then when I select R from the next Slicer, it gives me the available selections...
    and so on -- a flow chart. A map.

+ 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. Macro to update pivot table filters from multiple pivot tables of different data sources
    By groblerdn85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2017, 05:10 AM
  2. Consolidating Filters in Pivot Tables
    By nmbell in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 02-09-2017, 11:56 AM
  3. Pivot tables, filters, report.
    By israelalvarado in forum Excel General
    Replies: 1
    Last Post: 05-26-2016, 02:45 PM
  4. Excel 2007 : Pivot tables filters
    By Squevil in forum Excel General
    Replies: 1
    Last Post: 11-04-2011, 10:30 AM
  5. Pivot tables - Multiple filters across 2 tables
    By shoesterix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2011, 05:02 AM
  6. [SOLVED] Advanced filters in Pivot tables ?
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 12-14-2005, 11:25 AM

Tags for this Thread

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