nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Hide results based on criteria in a column

User_I3A7A

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 - y

2 - x

3 - y

Sorry if this makes no sense, I honestly don't know how to word this

Find more posts tagged with

Comments

Gianni Ceresa

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?