Hide dimension when expression is zero

[#1]

Hi all,

I have a chart with multiple dimensions (Name and Phone number).

I have one expression, called "Year Sales". The expression shows the sales of that year (a bit more complex than sum(Sales), but that does not matter).

I want to hide all names without any sales, basically all names with Year Sales = 0. In my example below, the row of customer C should be gone.

Guess I could do this with a dimension "supress when value is null", but I do not know how to re-write the calculated dimension for "Name" so that every line with "Year sales = 0" would become "Null()".

If possible to solve it a different way, that is also fine with me.

Thanks in advance!

[avinashelite]

Did you check the suppress zero values in the presentation tab of chart properties ??

[dineshraj]

Hi Wiebke,

Try this in text color expression

If(sum(Sales)=0,White())

Thanks and Regards

[#4]

Yes, "suppress zero-values" of that expression is checked off.  (there is a "V" in the box).

[miguelbraga]

Try this in te script, lad:

If([Year Sales] = 0, null(), [Year Sales]) as [Year Sales]

Best regards,

D.A. MB

[avinashelite]

will be able to share the sample data ??

[miguelbraga]

Check this out:

MB

[effinty2112]

Hi Wiebke,

                    If the field your summing to get Year Sales is called Sales then try:

Sum({$<Sales = {">0"}>Sales}

good luck

Andrew

[trdandamudi]

Please see the attached for the solution:

[#10]

The dimension is not called YearSales.

The expression to get the YearSales is a lot more complex. I named it Year Sales, but the expression is:

sum({$<Year=,Month=,Week=, YTD=>} Sales)

I cannot just copy your example, because then I would lose all the other information I've got there (being the "=" signs).