??? -- Filtering Slicer Output with another Slicer, based off of the original dataset that was filtered... ... lol

[BOTJ33F]

I realize that sounds absolutely ridiculous, but the concept is very much what I need.

This is based off of System Condition Codes (SCC) for Work Orders in SAP.

I have two columns of data - FROM (starting Code) and TO (finish code).
Each digit (alpha/numeric) has a preset limitation to what SCCs it will allow.

I would like to be able to click on a filtering Slicer 1 on to F, and it will eliminate all other selections but the authorized in Slicer 2.
In Slicer 2, click R and it narrows the selection again with a filter into Slicer 3.
In Slicer 3, click U ... ...and so on.

Is this possible?

EXAMPLE:

The work has been completed on a vehicle and is put into F status by the shop.

• 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.

 

[BOTJ33F]

Did I break everyone's brain...?

 

[Bobjg]

Let me preface that this was a 1st for me and I actually wanted to learn this so I can use it also. It can be done, you will need to add column/s (not sure if you are working off of a Pivot table) to allow for the function to generate the type of Slicer you need. Take a look at this vid and watch it all the way through,

. It will give you some ideas that you can apply.

Hope this helps, it did for me.