we must exclude clients

[#1]

good afternoon
such a task

we must exclude clients who bought mango

Client, Product,    Date,       Sales

1,       Apple,    01-01-2015,  750

1,       Mango,  01-02-2015,  450

1,       Limon,    01-02-2015,  350

2,       Apple,    01-01-2015,  1750

2,       Limon,  01-02-2015,  550

3,       Limon,    01-01-2015,  25

We choose from the list of mango

We see in the table clients 2 and 3

is it possible?

Thanks

[Chanty4u]

try this

sum({<Product=-{'Mango'}>}client)

Excluding values in Set Analysis

[Kushal_Chawda]

try this

sum({<Client=e({1<Product={'Mango'}>})>}Sales)

[#4]

we can choose the list of lemon or apple... or mango and lemon , that is a random selection

[Kushal_Chawda]

Do you mean that based on selection, you want to exclude that product?

[#6]

Yes exactly

[Kushal_Chawda · Accepted solution]

create the variable as vExclude on front end with below expression

=concat(chr(39)&Product&chr(39),',')

Now use the set analysis as below

sum({<Client=e({1<Product={$(vExclude)}>})>}Sales)

This will show the error but it will work..

[#8]

Many thanks

[Kushal_Chawda]

Welcome

[uacg0009]

Hi Kush,

I'm also interested in this question, and I saw your answer, but I tried it, it didn't work, I just don't know how to use it to make it work, could you please help me to check my attachedment?

Thanks a lot!

Aiolos Zhao