Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yes you have to use Union operator in between the set analysis
=Sum({<Region={'South','West'}> + <ProviderID = {'ABC'} >} Sales)
Hope that helps
Try like this..
=Sum({<Region={'South','West'}, ProviderID = {'ABC'} >}, Sales)
=sum({<Region={'South','West'}>+<ProviderID = {'ABC'} >}Sales)
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
ooops...
i got the wrong..
try expression by Clever, it should work...
Yes you have to use Union operator in between the set analysis
=Sum({<Region={'South','West'}> + <ProviderID = {'ABC'} >} Sales)
Hope that helps