5 Replies Latest reply: May 8, 2017 4:35 PM by Sohail Ansari RSS

    Hide dimension where measure is null or 0?

    Dan Mercer

      Hello,

       

      Looking to see if there is a way to not display all months when a field is zero or null?  I've got a budget to actual line chart.  I don't want to show values for months that haven't happened yet.  Our data is currently minimal, and will be updated via an excel upload. I've tried a few IF statements to no avail. Picture is below (yes, the values are negative on purpose). 

       

      Capture.PNG

      Thanks in advance