Show/Hide With List Box and Straight Table

[#1]

I have a List Box which is populated via an Inline data set

Load * Inline [

FieldNameTest, TableNameTest

Column_1, TableA

Column_2, TableA

Column_3, TableA

];

I also have a Straight Table that uses the data.  I need a way to conditionally Show/Hide columns based on the List Box selection, but cannot figure out the expression I need to do this.  I've tried conditional expressions on the Straight Table columns such as FieldNameTest = 'Column_1' but no matter what i try it doesn't seem to work.  When I try FieldNameTest = 'Column_1', it will Show/Hide for the first column, but not for the second.

Any suggestions on how to do this?

[#2]

Try using this in the expression "Conditional" formula:

SubStringCount(GetFieldSelections(x.Fact, ',' ,Count(Distinct x.Fact)), 'Net Sales $')

• x.Fact is the field from the inline load
• 'Net Sales $' is the name of the field (the expression you want to show).