OR condition in Set modifier

[PrashantRupani]

I have this set analysis expression : sum({1 <Year={1997},[Customer City] = {'London'}>} Sales)

I understand this will pull the sum of sales of year 19997 AND London. 

How to modify this expression if the condition is to show sum of sales for 1997 OR London?

[Nicole-Smith · Accepted solution]

You can use + between sets to create an OR condition:
sum({1 <Year={1997}>+<[Customer City] = {'London'}>} Sales)

[PrashantRupani]

Ok I see what you saying.

 + is an UNION Operator. So that will give results of 1997 or London depending on the data available in the database.  If there is data available for both, then it will give both. Correct? Can you confirm my understanding?

[MayilVahanan · Accepted solution]

Hi @PrashantRupani 

Yes, its will give both. 

Its like "OR" Conditon.

[PrashantRupani]

Thanks Mayil.