This content has been marked as final. Show 5 replies
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 ?