Set Analysis: 'OR' between modifiers

[#1]

From Help Menu for 'Set Analysis'

**

sum( {$<Year = {2000}, Region = {US, SE, DE, UK, FR}>} Sales )

returns the sales for current selection, but with new selections both in "Year" and in "Region".

**

Here ',' betweent {2000} and Region represents AND or Intersection.

How can I:

return the sales for current selection, but with new selections both in "Year" 'OR or Union' in "Region".

Thanks in advance.

Abi

[#2]

You could use the Symmetric Difference, but that will fail when both conditions are true. I think you need the Symmetric Difference combined with the Intersection.

It's messy, but I think it would be:

sum( {$<Year = {2000}>/<Region = {US, SE, DE, UK, FR}>} Sales ) +
sum( {$<Year = {2000}>*<Region = {US, SE, DE, UK, FR}>} Sales )

I think that should give you the Sales when either condition is met (but not both) combined with the Sales where both conditions are met. Logically, that should give you everything where either condition is met.

[johnw]

Maybe I missed something, but doesn't that simplify to just the union?

sum({<Year={2000}>+<Region={US,SE,DE,UK,FR}>} Sales)