Filter report using OR ?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

Im trying to filter a report to show if Status is = X OR Status is = Y 

And other field = whatever.

But I only have the option for AND

Am I missing something?


tks

Mick

Photo of Michael Graham | Insight Global UK

Posted 3 years ago

  • 0
  • 1
Photo of Keith

Keith

  • 0 Points
Mick,

When you hover over a filter, on the right side you have the options to Add, or remove a filter, and there's one more icon. That icon splits off that set of filters so you can get the combination of AND and OR that you are looking for.
Thanks Keith, that's great.
it's not very (intuit)ive though!
Photo of Andrew

Andrew

  • 2 Points
I still don't see how to switch "and" to "or"  - I do see how to group
Photo of Keith

Keith

  • 0 Points
Above the group or filters it allows you to choose "Any" or "All" are true
Photo of Andrew

Andrew

  • 2 Points
But between two groups - I want "All" of these conditions "or" "any" of these conditions...
Photo of Keith

Keith

  • 0 Points
then on the top one I would select All, then under one of your filters, when you hover over it, there is a +, - and a third symbol. That third symbol is to break out that filter into a new group. Then you'll have the ability to have the first group be "All" but the second subset of filters be "Any"
Photo of Keith

Keith

  • 0 Points
Photo of Andrew

Andrew

  • 2 Points
OK - Thanks - the issue was I had "all" at the top level which makes everything "and".  By switching to "any"  it makes things "or"