"Has any of" vs "Has all of"
When filtering a report, what is the difference between the option of "has any of" vs "Has all of"?
Answers
-
Has any of looks to see if any of the options are there before filtering the rest. Where has all of checks that the field Has every option before showing it.
If you found this comment helpful. Please respond with the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, and accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
@Mark.poole thank you for the info, but I am trying to put my brain around what you are saying and it is not making sense. Here's my deal, I have a report with 5 filters , one of the filters is for a contact column (Project Manager) there are 8 PM's available, I am filtering for only 1, do I use any or all?
I will be using the "current user" as well for another version of the report- do I use ANY or ALL?
I feel like an idiot not grasping this.
I also could not find any documentation regarding this question in SS help.
-
just do a filter for is one of and pick the name you want
If you found this comment helpful. Please respond with the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, and accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
