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

      Jernej