Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try something like this :
= Not IsNull(PriceBreak)
I thought conditional showing or not, needs an expression like IF(condition,1,0) to show if condition is true... ?
Try this in the conditional box of the expression:
If(GetSelectedCount(PriceBreak)=0, 1, 0)
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
i tried this one too but
same .. it hides but not showing again