Only show certain values

[wanyunyang]

Hi guys,

I have a table with columns named Customer_No and Customer. If I only want to show the customers with Customer_No=1, can I use set analysis instead of IF function?

I tried ({<Customer_No={'1'}>}Customer), it doesn't work.

Thanks for help!

[zebhashmi]

Edited

I did not get it

But maybe this can help you

Concat(Only({1<Customer_No={1}>}Customer),',')

[wanyunyang]

I'm just trying to do it both with IF and set analysis.

[OmarBenSalem]

I think that in this case; to handle this one to many rrelation; you'll have to use if condition.

stalwar1‌, do u confirm?

or maybe construct ur filter as follow: (not sure it'll work)

=aggr(only({<customer_no ={1}>}customer ),customer)

[Thiago_Justen_]

What about this:

Sum ({<Customer={"$(=If (Customer_No=1,Customer))"} Sales)