Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jasonseril
Creator
Creator

or in set analysis

Good day everyone,

The set analysis example below returns the sales for current selection, with new selections both in "Year" AND in "Region",

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

My question is how about for the OR, is there a way for this?

Thanks in advance and more pwoer...

Jason

13 Replies
johnw
Champion III
Champion III

Strange, your file is working for me in V9R5. Ah, well. At least it's working for you again in V9SR6.

Not applicable

Hai,

how can i place in group instead of single filed in the expression

Thanks

Hatus
Partner - Creator II
Partner - Creator II

Great! But how would you write a SET with OR and AND conditions?

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

kevinpintokpa
Creator II
Creator II

Thanks, this helped me solve a similar problem!