Adding 2 different sets

[zagzebski]

This should be so simple but I am drawing a blank

I have:

Product

A

B

C

D

Region

North

South

East

West

I want to add set analysis like below but it doesn't seem to work:

=sum(
{<[Product]={'A','B'}>}
Sales)

+

sum(
{<[Region]={'North','South'}>}
Sales)*.4

[CELAMBARASAN]

Hi,

Try this

(sum(
{<[Product]={'A','B'}>}
Sales)

+

sum(
{<[Region]={'North','South'}>}
Sales)) * .4

[israrkhan]

Try Below:

=num((sum({<[Product]={'A','B'}>}Sales)+sum( {<Region={'North','South'}>}Sales))*.4,'###0.00')

[yevgeniy]

Hi,

may be try

rangesum(sum(
{<[Product]={'A','B'}>}
Sales)

,

sum(
{<[Region]={'North','South'}>}
Sales))

*.4