Filter Person Number Using Copy Paste
In an OTBI Analysis, is there a way to filter a column based on a copied list of values? For example a column from an excel file or a comma separated list. For example, pasting a Person Number filter of 200 values out of 5,000 would be a lot easier than individually searching for each person.
I tried pasting the values from Excel, but it puts a space between each Person Number, for example 10021; 10897; 90853; 2864, but what is needed in the filter is 10021;10897;90853;2864
Any ideas experts? I'm also open to formula suggestions as well. Thank you!
Version (include the version you are using, if applicable):