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.
Hi,
Did you try spliting the slicers like this,
Slicer one: set([div1], [div2], [div3])
slicer two: except(set ([domain1]) )
Thanks,
RK