Hide Others when value is 0

[d_pranskus]

Hi

I want to create a chart to show top 5 Dimension values and then Others. I set Dimension Limits to to 6 top values and enable Others check box. This works fine when there are transactions for 6 or more dimension values. But when there are 5 or less, it still shows the Other label.

I had already asked this once Hide "Others" when value is 0

Still no solution. Any ideas?

Many thanks.

[MK_QSL]

It should not show the others if there are transaction less than or equal to 5... Please provide your sample apps

[israrkhan]

I Think you have unchcked, select missing in presentation tab...

check both checkboxes, "Suppress Zero Value" and "suppress Missing" on presentation tab...

[vijay_iitkgp]

I think Manish is correct. I have It should not show when Total number of Dimension is less  then Limit. But in case of Dimension having Null Values it will show Other also. I tried with Suppressing Null but still showing Other.