Oracle Transactional Business Intelligence

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?

Received Response
1
Views
1
Comments

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):

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    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