This content has been marked as final. Show 8 replies
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.