Categories
- All Categories
- Oracle Analytics Learning Hub
- 26 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 234 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Hide results based on criteria in a column
A bit unsure the words for this one. I want to show the results from one column based on another column's contents, but only if a particular value appears in the column.
Column A has values 1, 2 and 3. Column B has values x and y. If value 1 has a row for x and another row for y, I want to show it. If value 1 has only x I want to hide it. So in my below example, I'd only want to show the rows where column A has values 1 and 3.
Column A - Column B
1 - x
1 - x
1 - y
2 - x
3 - y
3 - y
Sorry if this makes no sense, I honestly don't know how to word this 
Comments
-
If value 1 has a row for x and another row for y, I want to show it. If value 1 has only x I want to hide it.
So why in the above example you say that you expect to see only rows where column A has values 1 and 3?
Value 3 doesn't have a row for "x", and therefore doesn't match your "show it" rule.
In what exact product (and version) you want to implement such kind of rule?
0
