5 Replies Latest reply: Jun 30, 2017 8:12 AM by Partha Kulkarni RSS

    Exclude zero value in Bar Chart

    RAM MUTHIAH M

      The site is not allowing me upload the image. I want to exclude the zero value in Bar Chart. Can anyone help in this regards?

       

      CY - Sum({<Year = {'$(=Max(Year))'}>} Sales)

      LY - Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)

       

       

       

      After applying

       

      CY - if(Sum({<Year = {'$(=Max(Year))'}>} Sales)>0,Sum({<Year = {'$(=Max(Year))'}>} Sales))

      LY - =if(Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)>0,Sum({<Year = {'$(=Max(Year)-1)'}>} Sales),'')