I have two fields ([Developer Name] and [Responsible Person]) in one table. The two fields might be different and they could be the same. Now, I need a list field, that I can use to show me where either of the two fields is = to the selected value in the list field.
For example. If I select "Bradley Isaacs" in the list field, then the table box/chart should display rows where [Developer Name] = "Bradley Isaacs" or [Responsible Person] = "Bradley Isaacs".
[In BAU date],
[Task Logged date],
SubField([Responsible Person], '(', 1) as Responsibleperson_SubField