Message when all values are zero

[Anonymous]

I am creating a pivot table. I am suppressing zero-values as I don't want a long list with 0 (most of my values are zero). Therefore I get a short list with the relevant non-zero values. This is fine, but in some cases all the values is zero, and I do not get any values at all. In this case only the headline is shown. For this case it would be useful if I could show a special message to the users. Does anyone know how I can do this?

[simondachstr]

Create a calculation condition in the General tab. If your used expression is 0 in total, then don't calculate the chart and display a customized error message instead.

[senpradip007]

Use customize error message

[Anonymous]

Calculation condition or conditional show with text box are the easiest solution, but if you really want it the way it is in screenshot:

Create calculated dimension: =IF(aggr(Sum(Approvals),YearMonth)=0, 'Nothing is approved', YearMonth)

Red color to text color: =IF(Sum(Approvals)=0, rgb(255,0,0))

Then we need two expressions with conditionals:

1st:

Condition: Sum(Approvals)<>0

Expression: Sum(Approvals)

2nd:

Condition: Sum(Approvals)=0

Expression: ' '

Calculated dimensions can sometimes bring performance issues.

[Siva_Sankar]

in chart properties,general tab, under calculated condition write something like =If(sum(approvals)>0, 1, 0)

and then click on error message button in general tab, click  calculation conditions unfulfilled, and write your custom message below.

see the attached example

[jagan]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[Anonymous]

I can't see any attached file...

[jagan]

Hi,

Attached again.

Regards,

Jagan.