Suppose I have a table of two Columns
| Col1 | Col2 |
|---|---|
| A | France |
| A | USA |
| B | Germany |
| B | Spain |
| C | Netherland |
| C | USA |
| D | Japan |
| E | USA |
| F | Canada |
How could I remove (in Quicksight) all the elements in Col1 if it contains USA at least once in Col2 ?
Final Table should look like this:-
| Col1 | Col2 |
|---|---|
| B | Germany |
| B | Spain |
| D | Japan |
| F | Canada |
CodePudding user response：
Create a calculated field. Using countIf and sumOver, an example would be like this:
sumOver
(
countIf({Col2}, {Col2} = 'USA'),
[{Col1}]
)
Then use a filter in your analysis, such as <your_calculated_field_name> Equals 0