8 Replies Latest reply: Mar 16, 2016 10:22 AM by Jernej Istenic RSS

    suppress dimensions with zero value

    Jernej Istenic

      hi all


      I would like to suppress dimensions with zero value in a bar chart (too many dimensions).


      Dimension: [Inventory Movement Type]

      Measure: Sum([Value (Custom)]


      I would only like the dimensions where Sum([Value (Custom)] <> 0 to appear.


      I have tried with if(Sum([Value (Custom)]) = 0, null(),[Inventory Movement Type]) but it gives me an error - Invalid dimension.


      Is there any other way to do it?


      Thank you for your help.


      Kind regards