Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one chart in this, am adding some dimension (for ex, used dmension is a location group) , in this group dimension return some values are zero, how toeliminate this zero, while displaying the chart.
Regards,
Senthil.K
Could you please upload sample qvw?
Use calculated dimension and set "Suppress when value is Null"
If([location group] <> '0',[location group])
Hi Cheliyan,
thanks for ur quick response , i will try and let know.
use calculated diemsion
Senthil,
Try this as calculated dimension:
=if (not isnull([location group]),[location group])
Thanks,
AS