Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Edited
I did not get it
But maybe this can help you
Concat(Only({1<Customer_No={1}>}Customer),',')
I'm just trying to do it both with IF and set analysis.
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)
What about this:
Sum ({<Customer={"$(=If (Customer_No=1,Customer))"} Sales)