Log In
Register
Home
New Member
September 11, 2020
Offline
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
July 16, 2010
Offline
Hi Bruno,
When selecting items in a single Slicer the criteria is considered OR. There's no setting available to change this, sorry.
Mynda
New Member
September 11, 2020
Offline
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.
1 Guest(s)
