I would like to exclude few values from the dimension in the chart, I am using if() statement, which is fine, however values which doesn't satisfy if() condition, comes as '-' separately. which is not required. Any workaround ?
You could use Only-statement to set which values are included
To hide the '-' values, you can click on "Supress When Value is Null" in properties, dimensions tab.
Hope it helps.
exactly. That's what I was about to say.
However, this checkbox "supress when ..." exists twice - once on the "dimension" tab and once on the "presentation" tab (in the dimension_area, in the bottom half).
You'll have to experiment a bit with those two.
Yep!! forgot the presentation tab!
Retrieving data ...