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

[trdandamudi]

May be as below:

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

[Anonymous]

This looks good, however I want to include other set analysis criteria.  Here is the actual expression I am using, but it's telling me there is an error

sum({<[XL Date]={"<=$(vLatestReturnsDate)"},[Ledger Type]={"Actual"},[Commission Of]={"Salads"}+[Trading Of]={"Salads"}>}[Hds/Kg KPI])

[ankit777]

it would be then

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

[ankit777 · Accepted solution]

Try this

sum({<[XL Date]={"<=$(vLatestReturnsDate)"},[Ledger Type]={"Actual"},[Commission Of]={"Salads"}>+

<[XL Date]={"<=$(vLatestReturnsDate)"},[Ledger Type]={"Actual"},[Trading Of]={"Salads"}>}[Hds/Kg KPI])

[Kushal_Chawda]

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

[Anonymous]

Replace the +[Trading Of]={"Salads"} with ,[Trading Of]={"Salads"}

[sunny_talwar]

Try this:

Sum({<[XL Date] = {"<=$(vLatestReturnsDate)"}, [Ledger Type]={"Actual"}, [Commission Of]={'Salads'}> +

         <[XL Date] = {"<=$(vLatestReturnsDate)"}, [Ledger Type]={"Actual"}, [Trading Of]={'Salads'}>}[Hds/Kg KPI])