Hiding an Expression value conditionally

[paul_scotchford]

Greetings All,

I have a pivot table chart that when I select a specific filter I require certain Expression Values to become hidden on my chart, for example if a

user clicks (or is already selected by association) a Retail Price Break, the Budget expression value should become hidden as budgets

are not at the Price Break granularity (Price Break is the finest grain for this pivot table chart).

I have tried using the Conditional option for the expression, but I can only get it to be hidden when the PriceBreak is >0, I would prefer if

I can test the actual list box (that contains the price breaks) has been selected.

Has anyone tried or know how to do this ?

Many thanks

Paul

[tresesco]

try something like this :

= Not IsNull(PriceBreak)

[peschu123]

I  thought conditional showing or not, needs an expression like IF(condition,1,0) to show if condition is true... ?

[Anonymous]

Try this in the conditional box of the expression:

If(GetSelectedCount(PriceBreak)=0, 1, 0)

[Anonymous]

peschu82: Not really...  it is enough to say

condition

If condition returns false, the object is hidden, otherwise it is shown.

The longer version

IF(condition,1,0)

works as well, but it is not necessary

[#6]

i tried this one too but

same .. it hides but not showing again