Enable column

[surajdhall]

Hi All,

I want to enable  Cust and Ctry columns in chart(table) only when user select it.

I have created island table, but not sure how to make it conditional.

The data is below. Please help me with the expression to make the dimensions Cust and Ctry conditional.

Data:
LOAD * INLINE [
Cust, Segment, Ctry, City, Sales
Claire Gute, Consumer, United States, Henderson, 353
Claire Gute, Consumer, United States, Henderson, 261
Darrin Van Huff, Corporate, United States, Los Angeles, 6365
"Sean O'Donnell", Consumer, United States, Fort Lauderdale, 15
"Sean O'Donnell", Consumer, United States, Fort Lauderdale, 1571
Brosina Hoffman, Consumer, United States, Los Angeles, 63461
Brosina Hoffman, Consumer, United States, Los Angeles, 6436
Brosina Hoffman, Consumer, United States, Los Angeles, 671
Brosina Hoffman, Consumer, United States, Los Angeles, 16716
];

Island:
LOAD * INLINE [
DimKey, Dim
Cust,Customer Name
Ctry,Country
];

Please help!

[sunny_talwar · Accepted solution]

Try this as your dimension enable conditions

=SubStringCount('|' & GetFieldSelections(Dim, '|') & '|', '|Customer Name|')
and
=SubStringCount('|' & GetFieldSelections(Dim, '|') & '|', '|Country|')

[surajdhall]

Thank you so much Sunny. Works like a charm.