Suppress Rows in Chart if Expression is zero?

[#1]

Hi,

I have a straight table chart with some calculated expressions. I would like to conditionally suppress the rows where the expression value is zero. Is this possible?

Thanks,

Magnus

[richard_chilvers]

In the chart tab called Presentation, there is an option (for each expression) to Suppress Zero-values.

If this is option is ticked for each expression in the row, my experience is that the row is not shown.

Regards

[#3]

Thank you. That may be true, but my problem in this case is that not all expressions are zero or null values. Any other ideas?

Best regards,

Magnus

[jagan · Accepted solution]

Hi,

Please let me know my understanding is correct,

If one particular expression value is 0, then you should hide that row?

If that is the requirement then do the following

Expression 1 = Sum(Value1), If this value is 0, then we will hide the entire row

Expression 2 = If([Expression 1] = 0, 0, Sum(Value2))

Expression 3 = If([Expression 1] = 0, 0, Sum(Value3))

If all the expression values are 0, then the row is not displayed.

Hope this helps you.

Regards,

Jagan.

[#5]

Thanks, worked perfectly. I created a new expression "Show", which gets value 1 or zero depending on other expressions.

Magnus