Forum Discussion
Slicers matching all selection
Hi,
I have been trying to crate a slicer in which all condition need to be true.
Normally a slicer would use an OR condition in filtering and I need to to use an AND instead.
To give you an example I want to select accounts which have purchased specificl multiple products. Calling products Prod1, Prod2 and Prod3 if I create a slicer selecting Prod1 and Prod2 the list of account I have is for people having EITHER Prod1 or Prod2 while I need accounts having both.
Is there a workaround I can adopt?
Thanks
8 Replies
Sorry I might not have explained myself properly.
Yes if I ctrl-select the two products it shows both of them but works with a logic of either-or.
To give you an example If I select Prod1 alone it gives me 10137 records, Prod2 alone gives 381 records. Selecting both the records are 10313 as some records bought both Prod1 and Prod2. What I would like the slicer to do is to show me the 205 records owning both Prod1 and Prod2.
Is there any way to do so?