Using except in a Slicer

[dekovite]

I have a report that has the following Hierarchy in a report :

Product
  Tower
     Division
        Domain

And the report needs to limit to 3 specific divisions which is fine as I have a slicer set to "set([div1], [div2], [div3])" which works as I'd expect, however we have a need to exclude a Domain that is part of [div2], so I've tried using the following :

"except (set([div1],[div2],[div3]), set ([domain1]) )" but this results in all of Tower down still showing.

Can anyone help explain where I'm going wrong, or what's missing - is it because I'm trying to exclude a member from the below level ?

I have tried including the other Domains, but some of these fall under other Divisions that we don't want to show in this particular report, so I don't think that would work.

Any advice is greatly received or pointers in the right direction if I'm coming at it from the wrong direction, so thanks in advance.

[RKMI]

Hi,

Did you try spliting the slicers like this,

Slicer one: set([div1], [div2], [div3])
slicer two:  except(set ([domain1]) )

Thanks,
RK