hide/show the entire straight table when selected value=<value>

[stevelord]

Hi, I know how to hide/show columns, text objects, and various other things, but am having difficulty making this entire straight table chart disappear if a condition is not met.  A particular client wants a count of something broken out by a dimension only they use, and I want the straight table to appear when this client is selected and to go away when not, so my condition would be ClientName='AcmeAnvils' for the table to show, and for it not to show if that is not selected.  The table has 1 dimension and 1 expression, and is as basic as can be otherwise.  (I want it to disappear when other clients are selected because other clients may want other things down the road, and I'd use this piece of real estate for them in the same way.  I might switch to a container object or something later if many clients start making a similar request.)

Thanks!

[JonnyPoole]

This will check if 'AcmeAnvils' is one of the possible values of ClientName and evaluate to TRUE if yes

substringcount(  concat( distinct  ClientName ,'-') , 'AcmeAnvils'  )

This will check if only one ClientName is selected and the ClientName is 'AcmeAnvils' and evaluate to TRUE if yes

getselectedcount(ClientName) = 1 and only(ClientName) = 'AcmeAnvils'

[stevelord]

Thanks! Can you also confirm the Properties tab and field in Chart Type Straight Table that I would place this expression in?  When I put the second expression in the calculation condition on the general tab, it makes the data inside the straight table appear and disappear.  I am hoping for something that will make the table object itself appear and disappear.  (Starting to suspect I'll need to go up into sheet properties or triggers or something now, but hoping for a show conditional checkbox and expression place somewhere inside the object still.)

[JonnyPoole · Accepted solution]

Sure. its on the LAYOUT tab under show / condition

[stevelord]

duh, thanks, not sure how I missed that but supposing there were a hundred things on every tab and I passed over the bit I needed.