Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
porkypig
Contributor II
Contributor II

Conditional Show Column

Hello all,

Long time listener, first time caller.

I have what I think is a rather unique problem in that I haven't been able to scour the internet to find a solution. 

I loaded an inline table in my data model to create a dimension with a number of other dimension names so I can use an extension to create a listbox with check-boxes to select dimensions from that list. I would like to have the table with data render based on the dimensions that the user selects from the listbox - if they choose "Customer", I would like to have the column for "Customer" appear based on that selection.

It seems that I need to tinker with the conditional visibility of the column, but I'm not sure how to write the condition. I'll need to do the same thing for a listbox with measures in it and have the table render once the user selects at least one dimension and one measure from each of the listboxes. Any help would be much appreciated!

Thank you

Labels (3)
1 Reply
porkypig
Contributor II
Contributor II
Author

I believe I've figured it out, the expression I used to achieve the desired result is:

=GetFieldSelections([Dimension])=('DIMENSIONNAME')

If there's a better way, please feel free to let me know