5 Replies Latest reply: Jun 15, 2015 8:08 AM by Tahir Abbas RSS

    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