Selections Table and Fields

[SevillaFe]

Hello, I need your help with $Table and $Field.

I have a Table1 and Table 2. They are joined and I need that my selections ignore Table1 except some fields. I´m trying that:

count({<$(=concat( {1<$Table={'Table1'} ,$Field-={'datum','[nummer1-nummer2]','Cluster','country','repair'}>} '[' & $Field & ']=',','))>} distinct([nummer1-nummer2]))

but when I selected "country" or "[nummer1-nummer2] i.e. it doesn´t work and I cannot find the problem

Thank you

[SevillaFe]

Hello, I need your help with $Table and $Field.

[SevillaFe]

I have a Table1 and Table 2. They are joined and I need that my selections ignore Table1 except some fields. I´m trying that:

[SevillaFe]

count({<$(=concat( {1<$Table={'Table1'} ,$Field-={'datum','[nummer1-nummer2]','Cluster','country','repair'}>} '[' & $Field & ']=',','))>} distinct([nummer1-nummer2]))

[SevillaFe]

but when I selected "country" or "[nummer1-nummer2] i.e. it doesn´t work and I cannot find the problem

[SevillaFe]

Thank you