Hie Guys,
I have a line chart with measure object "X" and dimension "Month". Now, the measure values are going to be zero for all previous months. I do not want those zero values to be displayed in the line chart. Is there a way to do this in Webi? I tried to create a variable to substitute Measure object X.
Variable = If (Measure Object =0) Then "" Else Measure Object. This did not work as the chart only takes measures and the variable is text. Anybody have any suggestions? Thanks.