8 Replies Latest reply: Oct 15, 2012 2:31 PM by Daniel Fleisher RSS

    Suppress Dimension if All Expressions Do Not Return Values

      Hello,

       

      I have a bar chart with one Dimension (Job Title) and two Expressions (avg(Hourly Rate) and (avg(Day Rate). I only want to see the dimension when it returns values for both expressions.  How is this accomplished?  I tried a select in field action as well so that the entire sheet would filter if the two expressions were true on sheet activate, but that didn't work. Please advise.