Categories
- All Categories
- 102 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 5 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How can I get "And" instead of "Or" to work with the same column?

Donna Fazio
Rank 2 - Community Beginner
Summary: I have a sales team member column. Each team member respresents a different function on the team. Example: Primary and Overlay. I want to create a report that shows only those accounts with Primary and the specified overlay team member
Content (required): I've tried doing a filter Territory Function = Primary . Then another filter "And" Territory Function = Overlay. This throws an error everytime
Version (include the version you are using, if applicable): OTBI
Code Snippet (add any code snippets that support your topic, if applicable):
0
Answers
-
No data found because where X = A AND X = B is always FALSE
Option A - click the and to change it to an OR (and click it again to change it back again)
Option B - multiple select
0