我正在寻找一种构建Smart Slicer [Slice_2]的方法，该选项在Slicer [Slicer_1]中已经选择了选项。例如，如果在切片器1上选择proj_short_name = nba-uc-02，则Slicer 2应显示剩余的全部除NBA-UC-02，如下所示。
excel随附以供快速参考： excel
I am looking for a way to build smart Slicer [Slice_2] that options out already selected option in Slicer [Slicer_1]. For instance if proj_short_name = NBA-UC-02 is selected on Slicer 1, Slicer 2 should display rest all except NBA-UC-02 as shown below.
Excel attached for quick reference: excel
发布评论
评论（1）
正如用户@mik在评论中所说的那样：
在理论上，这几乎不可能是可能的。切片机的目的 - 过滤，因此，如果您有2个切片机相互矛盾，那么什么都不会过滤。最好找到一个数据操作的其他想法。
As user @Mik said in a comment:
Hardly believe that this can be possible even in theory. The purpose of a slicer - filtering, so, If you have 2 slicers that contradicts each other nothing will be filtered. It's better to find an other idea for a data manipulation.