Set Analysis - OR

[Anonymous]

Hi

I have value field called 'Sales' and two category fields, for example 'CategoryA' and 'CategoryB'.

I want to include the expression sum(Sales) but only where CategoryA OR CategoryB equal "ProductA"

What would the set analysis be?

Thanks

A

[sunny_talwar]

Try this:

Sum({<Category = {'CategoryA', 'CategoryB'}>}Sales)

[ankit777]

Hi

try like this

if (CategoryA ='ProductA' or CategoryB='ProductA', sum(Sales))

[Chanty4u]

Try this

=sum({<Catageory={'CategoryA ',' CategoryB'}>}sales)

[Anonymous]

The fields are CategoryA and CategoryB and I want to include when the value in either CategoryA or CategoryB is ProductA

[Anonymous]

Hi

I'd rather not use if statements

[sunny_talwar]

May be this:

Sum({<CategoryA = {'ProductA'}> + <CategoryB = {'ProductA'}>}Sales)

[Chanty4u]

try

sum({<CategoryA='ProductA' or CategoryB='ProdcutA' >}sales)

[Anonymous]

Try

Sum({<CategoryA = {'ProductA'}>}Sales)+Sum({<CategoryB = {'ProductA'}>}Sales)

[Anonymous]

Sum({<CategoryA ={'Product A'} > +  <CategoryB={'Product A'}>}Sales)