sum with exclusion

[#1]

Hi all,

how can I exclude some from a calculation?

for example

Salesman Sales

A                   20

B                   35

C                   20

D                   21

A                   32

B                   2

and I want to make a sum of sales without B & C; and when I filter Salesman A, the sum must be just for Salesman A

Thanks,

Cosmin

[its_anandrjs]

Oh Sorry i forget now check and yes as always Gysbert is correct

You can try like

Dimension:- Salesman

Expression:- sum({$<Salesman-={'B','C'}>}Sales)

[Gysbert_Wassenaar · Accepted solution]

sum({$*<Salesman-={'B','C'}>}Sales)

[#4]

Hi,

the sum for B+C is ok

but if I filter salesman B the sum is also B+C

thanks

[#5]

Thanks Gysbert,

as always, it worked

best regards,

Cosmin

[fkeuroglian]

Hi, try this in the expression

SUM({<Salesman-={'B','C'}>} SALES)

see this link and this manual , will be useful to the set analisys

Fernando

Set Analysis - Ejemplos

[#7]

very useful

thanks