Hierarchy in slicers for pivot tables

Hi, perhaps someone can help.

I am setting up a dashboard to show results assessments for trainees. They are graded in 8 domains on a five point scale. The information is gathered in MS Lists and transported to excel in a query. From this query I made a pivottable with the results that feeds a horizontal bar graph with domains on the y axis. (This basically is a mimic of the output from MS forms but the capacity of Forms is limited for my group and domains)

Now I can slice the pivot table by name, no problem. I can slice it by “in training” or “ no longer in trainking”. And i slice it by “training phase (1-2-3-4).

Bit I dont know how to get a hierarchy in the slicers: set phase to 3—> only trainees in ohase 3 are in the name slicer. Selecr Not Longer in Training: only formee trainees pop up.

This works for the slicers as long as I dont connect them to the pivottable with the assessment results.

Intried with a name-phase-training pivot table, it works but the slice results dont carrynover tonthe assessment pivot table.

I worked with co pilot to work this out but apparently this would be one of the limitations of excel and a reason to go to power BI, which doesnt really work in our workspace.

So: any way to make the slicers influence eachother ánd influence the pivottable?

Thanks!