Display only those records which have one particular value for all records

[sbfernandes]

Greetings! I hope i can explain this well enough. I have a table with columns Number, Col1, Col2 which can be considered as a unique identifier. Column Flag shows a value which corresponds to Col3 (if it exists or not). I require to show a straight table that will display only those records in Number, Col1, Col 2 where all values in column Flag = "Exists". If even one record has a "Not Exists", then it should be excluded from the table. Please see attachment. Thank you.

[raman_rastogi · Accepted solution]

Try this Expression
if(Aggr(Only(Flag),Number)='Exists','AllFlagExists')
And exclude Zero Values

[sbfernandes]

Thanks! This works perfectly.