What is the actual result when entering multiple values in Set Analysis as filters?

[jblomqvist]

Hello,

I just wanted to check, what is the actual result when you enter multiple values as filters in set analysis?

E.g. I have sales analysis for customers where Dimension is Customer. The following is the expression:

Sum({$<ProductCategory={'Swimwear', 'Sportswear'}>}Sales)

Is Sportswear and Swimwear treated as an AND or an OR?

Would it give me results for customers who have purchased Swimwear and Sportswear?

[swuehl · Accepted solution]

It's like a selection in field ProductCategory, OR logic by default.

[jblomqvist]

Thank you for clarifying Swuehl,

So if I wanted to create set analysis where I want to know customers who have purchased Sportswear and Swimwear, how can I do that?

[swuehl]

Maybe like

Sum({<Customer = p({$<ProductCategory={'Swimwear'}>} ) * p({$<ProductCategory={'Sportswear'}>} ) >} Sales)

And if you want to limit the sales to these two product cats:

Sum(

{<

     Customer = p({$<ProductCategory={'Swimwear'}>} ) * p({$<ProductCategory={'Sportswear'}>} ),

     ProductCategory={'Swimwear', 'Sportswear'}  

>}

      Sales)