7 Replies Latest reply: May 27, 2017 10:03 AM by Gysbert Wassenaar RSS

    Eliminate Null Dimensions

    Seth Yates

      I created a bar graph that is a sum by month of the current month plus the previous 12 months.  Now I want to remove the months that have no values. I already tried going into PROPERTIES => DIMENSIONS => And Checking the box that says Suppress When Value Is Null.  This did not work.  Any idea how to remove the blank months?

       

      Formula:

      =NUM(SUM({$<[Month End Date]={">=$(=MonthStart(AddMonths(Max([Month End Date]),-12))) <$(=MonthEnd(Max([Month End Date]),+1))"}, [Fact Setup ID]={"576817","576818","576819","576820","576821","401258"}>} [Metric Value]), '###,##0')

       

       

      Thanks,

      Seth