Exclude 0 values from the Trellis Chart

[Anonymous]

Hello!

Is there a way to exclude the chart with 0 values from the Trellis Chart?  Right now, one of  my dimensions with 20 Values is in the chart...It would be more nicer if those charts in the Trellis have values..

Tks.

[#2]

Cacosta,

may you attach sample?

regards

Darek

[Anonymous]

Hi! Darek,

  Pls. see attached...Thank you for your time.

Rgds.

[MK_QSL]

Change your expression as below

MONEY(IF(SUM(Value)<>0,SUM(Value)/100000))

[#5]

Hi Manish,

this may be dangerous if you will have elements different than 0 but summing to 0.

regards

Darek

[#6]

I'm sorry, probably not yet woken up. I need coffee

Even if the condition is safe, it seems that does not work, so I suspect cacosta wants. It seems to me that the dimensional coordinates of each subchart of trellis will be the same and if any value is to coordinate, it is in all the others, even with a value of zero, this coordinate occurs. It seems that once saw a thread on this topic ...

I will try to check more later.

regards

Darek

[SunilChauhan · Accepted solution]

Hi,

all the MFR dimesnion values has similar age i.e 0-8,9-15.........................

zero value can not be removed untill every age has zero value. for example if for age 0-8 if value would zero

for one dimesion then on removing zero it helps

other wise not

try reducing your denominator from 100000  to 10000 or 1000.this will helps to show more values on charts

hope this helps

[Anonymous]

Sunil,

I just reduced my denomitor to 1000 to show some values.

Tks.