suppress zero values in Group

[#1]

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

[senpradip007]

Could you please upload sample qvw?

[anbu1984]

Use calculated dimension and set "Suppress when value is Null"

If([location group] <> '0',[location group])

[#4]

Hi Cheliyan,

thanks for ur quick response , i will try and let know.

[sujeetsingh]

use calculated diemsion

[amit_saini]

Senthil,

Try this as calculated dimension:

=if (not isnull([location group]),[location group])

Thanks,
AS