Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Found my own solution!
I used a calculated aggr.dimension. I changed my first dimension "Name" into:
=aggr(if(sum({$<Year=,Month=,Week=, YTD=>} Sales)<>0, Name), Name)
And I then used the "Suppress When Value Is Null"-option in the dimension tab.
It worked
Did you check the suppress zero values in the presentation tab of chart properties ??
Hi Wiebke,
Try this in text color expression
If(sum(Sales)=0,White())
Thanks and Regards
Yes, "suppress zero-values" of that expression is checked off. (there is a "V" in the box).
Try this in te script, lad:
If([Year Sales] = 0, null(), [Year Sales]) as [Year Sales]
Best regards,
D.A. MB
will be able to share the sample data ??
Check this out:
MB
Hi Wiebke,
If the field your summing to get Year Sales is called Sales then try:
Sum({$<Sales = {">0"}>Sales}
good luck
Andrew
Please see the attached for the solution:
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).