How to make a filter by rows

[#1]

Hi,  I need to make a filer between two tables, one table has data on columns, and the other has de colum´s name in rows

and that my filter be like:

Filter:

---------

field1

field2

field3

field4

field5

..

..

Thanks!!!

[settu_periasamy]

Good to know. Thank you..

[sunny_talwar]

You can use set analysis:

=SubStringCount(Concat({<$Table = {'TableName'}>}$Field,'|'),'Field1')

[settu_periasamy]

You need create separate table with needed fields ( data island).. i think you already created like that..

[MarcoWedel]

Hi,

maybe one solution could be:

hope this helps

regards

Marco