Show/Hide With List Box and Straight Table

Wed, 21 Mar 2012 15:18:35 GMT

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?

Show/Hide With List Box and Straight Table

Wed, 16 May 2012 15:50:00 GMT

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).

topic Show/Hide With List Box and Straight Table in Water Cooler

Show/Hide With List Box and Straight Table

Show/Hide With List Box and Straight Table