Show column if is not working

[43918084]

I would like to have a field to show in my pivot table ONLY if it is selected in an island table "Dim Selection"

my underlying load is 

Load

text( "Arr Lcl Num Ath") as ALN,

"BS impair",

FROM [lib://Loan/Tableau 2020 Sep Selective.xlsx]

(ooxml, embedded labels, table is data);

Then I have created the island table as below

Selections:

LOAD * INLINE [

Dim Selections
ALN
]

Then in the Data property where I have the Field [ALN], I put in the [Show Column If box] with below formula

   if(SubStringCount(GetFieldSelections([Dim Selections]),ALN)=1,1,0)

Unfortunately, when I select and deselect from the Filter pane, the ALN field never appears in my table.

Hope I can get some guidance to solve my problem.  Many thanks.

[agigliotti · Accepted solution]

Hi @43918084

There is a mistake in your expression:

Let's try using the below as your showing condition:

=GetFieldSelections([Dim Selections]) = 'ALN'

I hope it can helps.

Best Regards

[43918084]

Thanks a million for your guidance.  It works now 😁