Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sum({$*<Salesman-={'B','C'}>}Sales)
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)
sum({$*<Salesman-={'B','C'}>}Sales)
Hi,
the sum for B+C is ok
but if I filter salesman B the sum is also B+C
thanks
Thanks Gysbert,
as always, it worked
best regards,
Cosmin
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
very useful
thanks