Exclude field values and include field values in set analysis

[Gowtham174]

Hi All,

I have below table and i need to show as below.

Output1

Output2

=Sum({$<NAME2 -= {'A','B'}, NAME3 = {'C','E'}>} Sales)

its showing null, please help me on this.

Thanks,

Gowtham

[Channa]

if Name2 is null you want to show Name 3 values

[Channa]

IF(not isnull(Name2),Name2,Name3)

this should be UR name expression

for measure just put SUM(SALES)

[Gowtham174]

In name 3 field A and B is already present in name2

hence we need to show name3 which is not present in name2