Using or in set analysis

[zagzebski]

I am drawing a blank but don't feel like this should be that hard..

Provider ID

ABC

DEF

Region

South

West

North

East

I wanted to show the results of sales where :

Region = South or West or  Provider ID = ABC

[israrkhan]

Try like this..

=Sum({<Region={'South','West'}, ProviderID = {'ABC'} >}, Sales)

[Clever_Anjos]

=sum({<Region={'South','West'}>+<ProviderID = {'ABC'} >}Sales)

[zagzebski]

Thanks for the feedback. Unfortunately I think this wouldn't work because it says the record would need:

Region = South or West  AND Provider ID = ABC

I need the expression to be

Region = South or West  OR Provider ID = ABC

Steve

[israrkhan]

ooops...

i got the wrong..

try expression by Clever, it should work...

[CELAMBARASAN · Accepted solution]

Yes you have to use Union operator in between the set analysis

=Sum({<Region={'South','West'}> + <ProviderID = {'ABC'} >} Sales)

Hope that helps