Hi everyone, I've created a Pivot Table and to search my results I've added 3 slicers.
Unfortunately the result, after choosing some filters on the slicers are not meeting my expectation. I thought the slicers would consider AND to every filter I had applied, but It considers OR. The attached sheet shows it clear that after selecting Products 26 and 35 I would expect to see only Carmen and Joana as a results, not including John and Steve since they only have Product 35 on their list.
Appreciate your time,
Bruno
Hi Bruno,
When selecting items in a single Slicer the criteria is considered OR. There's no setting available to change this, sorry.
Mynda
Hi Mynda, appreciate your response. But do you think there is any alternatives other the using the slicer?
The idea behind this sheet is to create a search tool based on the data contained in the data table.