Merging Split Field and Removing Value

[Atx3765]

I had split out a column in the data manager to 3 total new columns. In a bard chart I am looking to merge the values which I accomplished with the below formula:

=pick(match($Field,'Competitor Name-1','Competitor Name-2','Competitor Name-3'),[Competitor Name-1],[Competitor Name-2],[Competitor Name-3])

BUT now I am wanting to remove a specific value from the Competitor list (for each dimension). How can this be accomplished?

[AshutoshBhumkar]

Hi,

Not clear with the question. Could you please elaborate more with an example?

That would be helpful for understanding.

[Atx3765]

I have a field (called Competitor Name) in my data that is";" separated values (i.e. sample1;sample2;sample3). I need to report on sample 1,2,3 separately so I split the field out into three total fields Competitor Name-1, Competitor Name-2, Competitor Name-3. Now to report on the individual values (summing Sample1 when occurring across all field Competitor Name-1 to 3) I used the below formula.

=pick(match($Field,'Competitor Name-1','Competitor Name-2','Competitor Name-3'),[Competitor Name-1],[Competitor Name-2],[Competitor Name-3])

However, I need to report on all values except for 'Sample-2' within Competitor Name-1, Competitor Name-2, Competitor Name-3.

[Atx3765]

I have resolved through the data manager, I manually made null the values I do not want to report on. Thanks!