Show column if is not working

43918084 — Mon, 20 Dec 2021 21:02:46 GMT

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.

Re: Show column if is not working

agigliotti — Thu, 18 Mar 2021 08:15:49 GMT

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 — Thu, 18 Mar 2021 08:20:05 GMT

Thanks a million for your guidance. It works now 😁