Does anyone know of a way of restrict values displayed ?
I have an expression (not dimension) that displays fields in colours, red or green using a formula on the background option. Whereas this works ok, I want to be able to display just the red fields. Is there a way of doing this ? It's difficult to change this to a dimension since the expression is a complex calculation and references other columns. It's such an easy requirement yet I just can't figure an easy way of doing it.
In general, you can suppress lines in a table chart where all expressions return zero or NULL for that line (there is an option for that on presentation tab in chart properties, enabled by default).
So you basically only need to create expressions that return zero for the lines that you don't want to show.
Having said this, this could get quite complicated if your expressions are depending on each other (referencing other expressions by their labels).
Could you maybe post a small sample app that demonstrates your chart and expressions?
