Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to combine the two values and display them in the filter?
Filters don't work because you can only select one data.
I tried this, but it doesn't work.
[data A] &'-' & [data B]
Hello,
I don't know why your code doesn't working,
here , I tried it on my sample data ,
I have created a new field with the combination of two fields as,
Country &'-'& Category as temp (in your script)
you can used this field in your filter.
hope this will help for you.
@louise119 look at this thread.
Thank you.
I tried below, but I think the data include "-". I wanna remove the "-", but I can't do that...
Country &'-'& Category as temp (in your script)