I am working with some data and have a column which has values but some instance it doesn’t have values at all and total would be “0”.
How can I hide such column? Please see sample code below and screen capture attached.
Thank you for posting on our forum.
We suggest developing a function that would scan members of each measure selected to the report. This function should check if at least one of the members differs from zero/null. Finally, filter out unwanted hierarchies from the slice.
Here is the JSFiddle we prepared for your reference: https://jsfiddle.net/flexmonster/3rq6somh/.
Please note that this approach only works for numeric fields and should not be used for fields of the other data types (for example, string field with
Please let us know if it works for you.
Looking forward to your feedback.
this solution only work if we have one single column, if we have multiple columns this solution hide all the column regardless of value 0.
Could you please modify the provided JSFiddle to demonstrate this behavior?
Looking forward to hearing from you.