Aggr condition

[Abhi999]

I have Two fields, Name,Test.

In test field I have data like yes or no. Like blow. But I want o show like once in test filed we have yes for test1 I want to show yes for all test1 records.

Name || Test

Test1   Yes

Test2 Yes

Test1 no

Test2 no